Line Charts - How to cope with missing values

Kate · Mar 21st, 2002, 12:26 PM

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.

Mark W. · Mar 21st, 2002, 01:17 PM

Quote:

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.

Kate · Mar 21st, 2002, 02:50 PM

thanks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 21st, 2002, 12:26 PM	#1
Kate New Member Join Date: Mar 2002 Posts: 2	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.

Mar 21st, 2002, 02:50 PM	#3
Kate New Member Join Date: Mar 2002 Posts: 2	thanks.