Lines not visible in an Excel line chart
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/ _______ argonaut wrote: 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? |
All times are GMT +1. The time now is 06:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com