View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Cannot see graph lines on the chart

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

Guy wrote:
Andy - yes.

"Andy Pope" wrote:


Hi,

Are the values of the series within the range of the axes scale?

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Guy" wrote in message
...

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.