Hi all,

I have been creating graphs using the stacked area type to display data for
data by year. However I have some years that have missing data. This then
plots as zero. I have been to tools, options, charts and clicked interpolate
for missing values but this doesn`t seem to work for the stacked area
chart...has anyone else found this? Has anyone found an acceptable work
around?
I`d be interested if anybosy has found anything similar, thanks in advance
for any help.

what do you want it to plot?

"Lasci" wrote:

Hi all,

I have been creating graphs using the stacked area type to display data for
data by year. However I have some years that have missing data. This then
plots as zero. I have been to tools, options, charts and clicked interpolate
for missing values but this doesn`t seem to work for the stacked area
chart...has anyone else found this? Has anyone found an acceptable work
around?
I`d be interested if anybosy has found anything similar, thanks in advance
for any help.

Just numbers for each year, they are for employment figures, but they aren`t
available for each year. I could interpolate myself and add in the values to
the spreadsheet, I just wanted to be able to create a graph quickly without
having to do all this...

"bj" wrote:

what do you want it to plot?

"Lasci" wrote:

Hi all,

I have been creating graphs using the stacked area type to display data for
data by year. However I have some years that have missing data. This then
plots as zero. I have been to tools, options, charts and clicked interpolate
for missing values but this doesn`t seem to work for the stacked area
chart...has anyone else found this? Has anyone found an acceptable work
around?
I`d be interested if anybosy has found anything similar, thanks in advance
for any help.

Cannot you put #N/A in the cells containing 0 ??
I think it does not read these values


--
Pierre
------------------------------------------------------------------------
Pierre's Profile: http://www.excelforum.com/member.php...fo&userid=3754
View this thread: http://www.excelforum.com/showthread...hreadid=471683

Unfortunately this trick is ineffective in an area chart. You can only make it work
with real blank cells. If you have some kind of lookup formula, you'll have to
delete the ones that have no returned data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Pierre wrote:

Cannot you put #N/A in the cells containing 0 ??
I think it does not read these values

In the line graphs, I have managed to make excel ignore the missing values,
but only by having another data set that has all the values in the graph, and
then blanking out this line by changing the colour. This is the only work
around I seem to have found so far.....

"Jon Peltier" wrote:

Unfortunately this trick is ineffective in an area chart. You can only make it work
with real blank cells. If you have some kind of lookup formula, you'll have to
delete the ones that have no returned data.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Pierre wrote:

Cannot you put #N/A in the cells containing 0 ??
I think it does not read these values