| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
I can't get any lines in my line chart
For some reason, I can't get the lines to display in the attached line
chart, only the data points. Any suggestions would be greatly appreciated. Alex |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
I can't get any lines in my line chart
I didn't open the attachment, probably nobody will.
Do you have blanks in the data? That's generally not good practice. You can get around it if the cells are truly blank. Go to the Tools menu, choose Options, click on the Chart tab. At the top, select Interpolate for how Excel should chart blank cells. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Alex" wrote in message ... For some reason, I can't get the lines to display in the attached line chart, only the data points. Any suggestions would be greatly appreciated. Alex |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
I can't get any lines in my line chart
That did it. Thanks, Jon!
Alex "Jon Peltier" wrote in message ... I didn't open the attachment, probably nobody will. Do you have blanks in the data? That's generally not good practice. You can get around it if the cells are truly blank. Go to the Tools menu, choose Options, click on the Chart tab. At the top, select Interpolate for how Excel should chart blank cells. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Alex" wrote in message ... For some reason, I can't get the lines to display in the attached line chart, only the data points. Any suggestions would be greatly appreciated. Alex |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I stop a line in the middle of a chart? | Charts and Charting in Excel | |||
| Combine stacked column and line chart w/series lines | Charts and Charting in Excel | |||
| Can I link timeline labels to a line chart? | Charts and Charting in Excel | |||
| How do I create vertical lines in a line chart? | Charts and Charting in Excel | |||
| Formatting lines between data points in a line chart | Charts and Charting in Excel | |||
Linear Mode
