Creating a graph using Excel Sheet

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.

Answer
Answer

If you are just interested in the time difference, it is only those values that you should be plotting one set of values

Image

Hope this helps,
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Answer
Answer

All that you need do is select the values and then right click and select Format Axis and check the box for Logarithmic scale

Image

Even then, because Time values are so small, they are barely visible.

However, changing the Log Base to 1,000, which is the maximum, will probably make the scale easier to use.

Image

Hope this helps,
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated April 14, 2025 Views 332 Applies to: