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?
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.
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?
- It would appear that using format cells > number does not work!? I am non the wiser as to why that wasn't working or why in the "home" ribbon it was showing those columns as numbers when they were not. But using isnumber() is was able to diagnose the problem. This did fix it.
I was also able to quickly find the solution to my further query, for those interested, as where column C+D are in the example already "numbers" they are formulas in the proper spreadsheet. Using value() on any output will convert it to a number.Chris,
1) In most cases if your values are at the left side of the cell they are text, numbers are aligned to the right site. As far as you din't apply any alignment formatting.
2) Green sign in the cell is also a good sign what you may have wrong format
3) Just format the cell from text to number won't affect values already entered. You shall re-edit your cells to apply new format. As an example you may press F2 on any of such cells and Enter - it'll be converted to number
4) I'm not sure about your formulas, perhaps that's more easy way to return numbers. But yes, VALUE() shall work.
