creating a chart with auto fillin of missing date points?

[Rob]

I have dates in column A and a value in B. I want to create a line graph
showing values across ALL dates using the points I have actual dates for as
the end points for each line segment. How do I get Excel 2003 to do that?
Thanks!

[Debra Dalgleish]

Select the chart
Choose Tools>Options
On the Chart tab, for 'Plot empty cells as', select Interpolated
Click OK

Rob wrote:
> I have dates in column A and a value in B. I want to create a line graph
> showing values across ALL dates using the points I have actual dates for as
> the end points for each line segment. How do I get Excel 2003 to do that?
> Thanks!
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

[Tushar Mehta]

Create the chart, select it, then select Tools | Options... | Chart
tab. Set the 'Plot empty cells as' option to 'Interpolated' and you
should be all set.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>, [email protected]
says...
> I have dates in column A and a value in B. I want to create a line graph
> showing values across ALL dates using the points I have actual dates for as
> the end points for each line segment. How do I get Excel 2003 to do that?
> Thanks!
>
>
>