creating a chart with auto fillin of missing date points?

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

Debra Dalgleish

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
How to create a bubble chart with more than 2 variables. 0
Excel 2010 - Line Chart with Mulitiple Data Sets 1
VBA - exporting serial letters to single documents 0
Occasional meter readings chart 0
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Duplicate Dates Problem 1
Graph Line Width ? 1

Top