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
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 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" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>
That did it. Thanks, Jon!
Alex
"Jon Peltier" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>>
>>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks