I'm trying to create a time series line chart over 20years. But some for some of the years the data is missing and Excel refuses to join it up. How do I make it? Doing 'hide' joins it up but also gets rid of the years and I need to retain the scale of the graph.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Line Charts - How to cope with missing values
- Thread starter Kate
- Start date
Excel Facts
Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
On 2002-03-21 11:26, Kate wrote:
I'm trying to create a time series line chart over 20years. But some for some of the years the data is missing and Excel refuses to join it up. How do I make it? Doing 'hide' joins it up but also gets rid of the years and I need to retain the scale of the graph.
If by "join it up" you mean interpolate, and if the missing data is represented by empty cells after selecting the chart choose the Tools | Options... menu command and click on
the "Plot empty cells as: Interpolated" option located on the Chart tab.
Upvote
0
Similar threads
- Replies
- 0
- Views
- 209
- Replies
- 0
- Views
- 102
- Question
- Replies
- 0
- Views
- 93
- Replies
- 0
- Views
- 840
