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

Click For Summary
SUMMARY

The discussion focuses on creating graphs in MS Excel using performance data from three different computers. Key metrics include CPU Percentage, Memory Usage, and disk usage statistics. A critical insight is the need to normalize the data to ensure meaningful visual representation, as values like CPU Percentage (e.g., 12) are significantly smaller than disk usage figures (e.g., 9.82901E+11). The suggestion to plot data as fractions relative to the highest value ensures clarity and accuracy in the graphs.

PREREQUISITES
  • Familiarity with MS Excel graphing tools
  • Understanding of data normalization techniques
  • Basic knowledge of performance metrics (CPU, Memory, Disk Usage)
  • Ability to interpret scientific notation in data
NEXT STEPS
  • Learn how to normalize data in Excel for accurate graphing
  • Explore MS Excel's chart types and their appropriate use cases
  • Research methods for visualizing large discrepancies in data scales
  • Study best practices for presenting performance metrics in reports
USEFUL FOR

This discussion is beneficial for data analysts, IT professionals, and anyone involved in performance monitoring and reporting using MS Excel.

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   Reactions: harborsparrow and pbuk

Similar threads

  • · Replies 1 ·
Replies
1
Views
1K
Replies
9
Views
29K
  • · Replies 75 ·
3
Replies
75
Views
7K
  • · 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
3K
  • · Replies 2 ·
Replies
2
Views
5K