Lines not visible in an Excel line chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm creating a line chart in Excel 2004 for Mac. The lines themselves will
not show on the chart. Have worked with the data series and other chart
settings already with no results. Anyone know of this problem or a fix?
 
Do you have blank rows or columns in between data in the worksheet? If
so, Excel is following its default behavior for blanks by leaving gaps
in the chart. Select the chart, choose Options from the Tools menu, and
on the Chart tab, under Treat Blank Cells As, choose Interpolate.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top