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
How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
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
- 121
- Replies
- 0
- Views
- 69
- Question
- Replies
- 0
- Views
- 70
- Replies
- 0
- Views
- 817
