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