Chart % difference From

[cereldine]

I have used the inbuilt functionality of a pivot chart to look at a
specific value and then compare it to the corresponding value for the
year before, this gives me results such as 6.5%.

My data only goes back as far as 02/03 and so the values for these
records are blank, However these records do appear in my chart giving
it a strange look as the first 12 month records are blank and the
values starts for April 03/04.

My question is, is it possible to exclude the null or blank values in
my chart, thus giving it a more professional appearence?
Thanks

 

[Bernard Liengme]

1) Replace the nulls by =NA()
or
2) Click chart; use Tools|Options ; open Chart tab; specify how blanks
(missing/empty cells) are to be treated.

Try to make Subject match the question

best wishes