ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   I can't get any lines in my line chart (https://www.excelbanter.com/charts-charting-excel/103670-i-cant-get-any-lines-my-line-chart.html)

Alex

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





Jon Peltier

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





Alex

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








All times are GMT +1. The time now is 07:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com