Lines not visible in an Excel line chart

A

argonaut

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?
 
J

Jon Peltier

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/
_______
 

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

Overlay line graph points on bar graph 1
sideways stacked bar charts with line series on the same axis 0
Gantt chart duration not showing 0
Odd Chart Format Results 1
Excel line chart not displaying correctly 1
Line chart with dotted lines rendered poorly in presentation mode 0
Flatline on line chart 1
changing trend/series data by manipulating chart lines? 1

Top