Forum Discussion
Excel - Line Graph adds data series as graph title, ignores one data series for no reason.
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
Okay,
Step 1
Step 2
when
when
with
after that
and
Double click horizontal axis now to format and link to source
Now you may do some cosmetic - stay on chart, Chart tools section will appear in ribbon, at very left under Add chart elements you may add/change title, labels, etc.
Thanks for trying but it's still not there. I don't know what "format" options I should use (in the last step). The verticle side of the chart is showing 0.00 at bottom to 1.00 at the top.
Even if I click on this and change the maximum to 3000 (so all the numbers are within that range so should be drawn), no lines are drawn.
Format axis on Step 3 is for the horizontal axis to show your time as in table, in time hh:mm format, not as numbers.