creating a chart with auto fillin of missing date points?
 

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!

Select the chart
Choose ToolsOptions
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

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