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

Join the discussion
Ask a follow-up here, or get your own question answered by working scientists, mathematicians and engineers — people, not an autocomplete.
Real named experts · corrections over time · the nuance an AI answer skips
1 reply · 1K views
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:
Physics 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   Reactions: harborsparrow and pbuk