| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add line to a stacked area chart already created | Charts and Charting in Excel | |||
| How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
| Line chart - date line association gone mad! | Charts and Charting in Excel | |||
| Strange Problem with Chart and Plot Visible Cells Option | Charts and Charting in Excel | |||
| Linking 2 Excel Sheets, Anticipating Lines. | Excel Worksheet Functions | |||
Hybrid Mode
