Cannot see graph lines on the chart

G

Guest

I've created a chart with 3 data series. I chose "lines with markers" as the
format. For each series, the data markers appear correctly, but there are no
graph lines joining them up. I've checked out "Format data series" ....
Pattern tab .... and can see the lines in the sample, but they just don't
appear on the chart.
 
A

Andy Pope

If you want to email the offending file direct to me I will take a look.

Cheers
Andy
 
A

Andy Pope

Select the chart and use the menu, Tools > Options > Chart. Check the
interpolate option in order to get the lines plotted.

You have points for the category axis but not corresponding y value. The
current setting for empty cells is not to plot, which is why the points
are there for data with no line joining the points.
With the interpolate option a line will be plotted between points.

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Markers only appearing on comparison line graph 1
Shaded 'radar' graph with markers 2
How to adjust the weight of markers 2
Zero length string on chart 1
Excell Chart-how do I change all the lines and points without cha. 3
Excel 2007: Lines not displaying on Scatter Plots 1
Graph Line Width ? 1
Stacked column chart narrow bars wanted 5

Top