| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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! |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart Date X Axis | Charts and Charting in Excel | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
| Missing values in Excel Line Chart | Charts and Charting in Excel | |||
| Line chart - date line association gone mad! | Charts and Charting in Excel | |||
| Creating a Date Selector in Excel VBA? | Excel Discussion (Misc queries) | |||
Hybrid Mode
