Creating a Graph using MS Excel -- help with a couple problems please

Click For Summary
To create a graph from the provided data of three different computers, it's essential to consider the scale of the values being plotted. The discussion highlights the need to normalize the data due to the significant differences in magnitude, particularly between CPU percentages and disk usage values. Normalizing the data allows for a more accurate visual representation by converting all values to a fraction relative to the largest value among the computers. This approach ensures that smaller numbers, like CPU percentages, can be effectively compared with larger values, such as disk usage totals.
zak100
Messages
462
Reaction score
11
TL;DR
I am facing problem in creating a graph using MS Excel. I have got fractional data. Also the graph which is created by MS excel ignores some fields.
Hi,

I want to create a graph from the following data. The data is related to 3 different computers but the fields are same:

Please provide me the steps.

Garph1 BS

CPU Percentage 12

Memory Usage 15773696

sdiskusage total 9.82901E+11

sdiskusage used 1.41429E+11

sdisk usage free 7.91472E+11

sdisk usage percentage 15.2

virtual Memory 10234679296

rss 15773696

Time 1.026669979

Graph2 SS

CPU Percentage 2

Memory Usage 15769600

sdiskusage total 9.82901E+11

sdiskusage used 1.41429E+11

sdisk usage free 7.91472E+11

sdisk usage percentage 15.2

virtual Memory 10545913856

rss 15769600

Time 1.026956081

Graph3 BSBS

CPU Percentage 12

Memory Usage 15773696

sdiskusage total 9.82901E+11

sdiskusage used 1.41429E+11

sdisk usage free 7.91472E+11

sdisk usage percentage 15.2

virtual Memory 10234679296

rss 15773696

Time 1.071877241

Zulfi.
G1.jpg
 
Last edited by a moderator:
Technology news on Phys.org
What is the graph supposed to show?
If you plot numbers like 12 and numbers like 9E11 on the same scale you won't see 12, it's too small by orders of magnitude. You could normalize the data: Show everything as fraction relative to the computer with the largest value.
 
  • Like
Likes harborsparrow and pbuk
Learn If you want to write code for Python Machine learning, AI Statistics/data analysis Scientific research Web application servers Some microcontrollers JavaScript/Node JS/TypeScript Web sites Web application servers C# Games (Unity) Consumer applications (Windows) Business applications C++ Games (Unreal Engine) Operating systems, device drivers Microcontrollers/embedded systems Consumer applications (Linux) Some more tips: Do not learn C++ (or any other dialect of C) as a...

Similar threads

  • · Replies 1 ·
Replies
1
Views
1K
Replies
9
Views
29K
  • · Replies 75 ·
3
Replies
75
Views
6K
  • · Replies 6 ·
Replies
6
Views
3K
  • · Replies 2 ·
Replies
2
Views
6K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 13 ·
Replies
13
Views
5K
  • · Replies 6 ·
Replies
6
Views
2K
  • · Replies 2 ·
Replies
2
Views
4K