creating a chart with auto fillin of missing date points?

  • Thread starter Thread starter Rob
  • Start date Start date
R

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!
 
Select the chart
Choose Tools>Options
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!
Click to expand...
 
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
 
Back
Top