Plot a Only 1 Line Chart with 2 values for analysis find attached

[E_newbie]

for performance analysis purposes, i'm trying to draw only 1 line which represent the throughput/cpu value every throughput what was the cpu utilization for it?

Please help! i believe this feature is not there, i tried pivot charts but it shows blank chart!!


Thanks

[NickyC]

Hi
did you try an x-y scatter, something like this?

[lmp]

Hi,

not sure what the question is. Are the CPU values meant to be the X axis labels? If so, are you aware that they are not in an ascending order? You can still use them in a line chart.

To quickly create a chart, delete the "cpu" text in cell B4, then click a cell in the data and click Insert > Line chart. The CPU numbers will then be the X axis labels, but they are treated purely as categories and not sorted as to their value.

You can of course chart the data in an XY chart, but then you will see a funny zig zag pattern.

Please explain what you really want if that does not do the trick.

[E_newbie]

Thank you the trick here was sorting the data in the sheet, previously i was doing the same you're mentioning here but it returns unreadable chart like a baby you gave him a pencil , but anyway, thanks for you...

E_newbie

Hi,

not sure what the question is. Are the CPU values meant to be the X axis labels? If so, are you aware that they are not in an ascending order? You can still use them in a line chart.

To quickly create a chart, delete the "cpu" text in cell B4, then click a cell in the data and click Insert > Line chart. The CPU numbers will then be the X axis labels, but they are treated purely as categories and not sorted as to their value.

You can of course chart the data in an XY chart, but then you will see a funny zig zag pattern.

Please explain what you really want if that does not do the trick.