Forum Discussion
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 graph to be made visualising the latency data. According to all help files this should be so easy. But it's not.
What I need is someone to tell me what needs doing to make the graph as described below. I will be providing daily reports so will be using formulas to strip the latency from columns E and F and display the results in columns C and D as in the spreadsheet.
The graph simply needs to have column B be the horizontal axis, and plot lines using the numerical data on rows C and D. This shouldn't be rocket science. I am guessing it's freaking out due to some column not being formatted correctly. Column C and D MUST contain formulas to make the process quick.
Please confirm the steps to take to make this work. I am ashamed to admit excel has let me down here, colum B is formatted to "hh:mm", and C+D are numerical already.
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
- Hi I don't know what you mean in step 2 "change series to C" there is no "change series" option in the right click menu. You have to explain every step in full detail. I've never made a graph in 2010 and at this rate never will. Imagine explaining it to your grandad!
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.
