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

  • Thread starter zak100
  • Start date
  • #1
zak100
Gold Member
462
11

Summary:

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.

Main Question or Discussion Point

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:

Answers and Replies

  • #2
34,395
10,479
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

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

  • Last Post
Replies
4
Views
772
Replies
4
Views
578
Replies
1
Views
623
  • Last Post
Replies
2
Views
3K
Replies
1
Views
5K
  • Last Post
Replies
7
Views
62K
Replies
9
Views
898
Replies
6
Views
737
Replies
2
Views
3K
  • Last Post
Replies
10
Views
11K
Top