Forum Discussion
Solved
Excel - Line Graph adds data series as graph title, ignores one data series for no reason.
Please see attached file (Is Excel 2010 format, no I cant update it's a works computer). I have been tasked with measuring the latency as we are having connectivity issues. Part of that requires a...
Chris, step by step.
Most probably vertical axis is from 0 to 1 since you didn't convert values in columns C and D from text to numbers. To check, in any empty cell you may enter
=ISNUMBER(C3)
if FALSE you have text.
It shall be green sign at top left corner of each of such cell
If so the easiest way to convert is to select all such cells in C and D, you will see the icon on the top left of selection
Focus the mouse on it and from drop-down menu select Convert to numbers
Does it work?
Hi Chris,
1) Convert C and D to numbers, they are text now
2) Right click on graph, change series on C and and add another series from D
3) Edit here horizontal axis and select B
Please see attached