Hiding zeros in dynamic charts

[Carla]

I am using a dynamic range to plot a chart area (using various charts). The
dynamic named range data I'm using contains zero values/blank cells.

How can I hide zero values or "" within a dynamic range to prevent them from
appearing in my chart information?

Much appreciated.

[Bernard Liengme]

Don't use blanks but use NA() in their place
OR
Select chart; use Tool | Option | Charts and specify how missing data is to
be treated.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Carla" <Ca...@discussions.microsoft.com> wrote in message
news:3B2E6FA0-94D2-4B7C...@microsoft.com...

[Carla]

Thanks for the reply. I have already tried using NA() but the dynamic range
stills picks it up so I get NA() as a chart label & a zero value.

I've also tried select Tool-option-charts and tried 0;-0;;@ & 0.00;-0.00;;
they didn't work either.

Do you have any further suggestions.

Kind regards,
Carla

[Bernard Liengme]

Send us more details:
Were (what range) hold the x-values; what hold the y-value.
Show us the dynamic formula you are using - the whole point of the OFFSET in
the definition of dynamic ranges is to avoid plotting empty cells.

If you are using XL2003: do you know that if a chart is made from an Excel
List then it is automatically dynamic. In XL2007 "list" got renamed to
"table"
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Carla" <Ca...@discussions.microsoft.com> wrote in message

news:7CB47D04-AFA8-4C95...@microsoft.com...