Line graphs and spaces between data

M

mschuknecht55

I have a line graph that is not showing the lines, just the data points. I
know it is because there are spaces inbetween the data being used. Is there
a way to still plot the line between points without taking all the spaces out
of my data? I also don't want to use a trend line. I want the actual line.
 
M

masterminx

Have you tried using the control key to select only the data, and not the
spaces in between, when setting the data range for your graph?
masterminx
 
B

Bob I

look in tools, options, chart.
Have you tried using the control key to select only the data, and not the
spaces in between, when setting the data range for your graph?
masterminx

:
Click to expand...
 
E

Echo S

mschuknecht55 said:
I have a line graph that is not showing the lines, just the data points. I
know it is because there are spaces inbetween the data being used. Is
there
a way to still plot the line between points without taking all the spaces
out
of my data? I also don't want to use a trend line. I want the actual
line.
Click to expand...

Open the chart, then choose Tools|Options|Chart and select Interpolated.
 
Top