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

In summary, the conversation is about creating a graph from data related to 3 different computers with the same fields. The three graphs, named Graph1 BS, Graph2 SS, and Graph3 BSBS, have data on CPU percentage, memory usage, disk usage, virtual memory, RSS, and time. The person asking for help is concerned that the graph may not accurately depict the data due to the large differences in values. The other person suggests normalizing the data to show it as fractions relative to the computer with the largest value.
  • #1
zak100
462
11
TL;DR 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.
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
  • #2
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

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

What is MS Excel?

MS Excel is a widely used spreadsheet software developed by Microsoft. It allows users to organize, analyze, and manipulate data in a tabular format using rows and columns.

How do I create a graph in MS Excel?

To create a graph in MS Excel, first input your data into a spreadsheet. Then, select the data you want to graph and click on the "Insert" tab. From there, choose the type of graph you want to create and customize it as desired.

What are some common problems when creating a graph in MS Excel?

Some common problems when creating a graph in MS Excel include incorrect data selection, missing data, and formatting issues. It is important to double check the data and make sure it is organized correctly before creating the graph.

How can I customize my graph in MS Excel?

There are several ways to customize your graph in MS Excel. You can change the chart type, add labels and titles, adjust the colors and fonts, and more. These options can be found under the "Design" and "Format" tabs.

Can I edit my graph after creating it in MS Excel?

Yes, you can edit your graph after creating it in MS Excel. Simply select the graph and make any desired changes. You can also update the graph automatically if the data in the spreadsheet is changed.

Back
Top