Hi

I currently have some data as shown below:

Item 1 0
Item 2 3
Item 3 6
Item 4 5
Item 5 0
Item 6 9

How can I exclude the zero items automatically, the data shown below is
going to change regulary and i do not want to have to keep change the source
data manually.

D

You can use AutoFilter to hide the rows with 0s as Chart does not display
data that's hidden.

HTH

"DMc2005" wrote:

Hi

I currently have some data as shown below:

Item 1 0
Item 2 3
Item 3 6
Item 4 5
Item 5 0
Item 6 9

How can I exclude the zero items automatically, the data shown below is
going to change regulary and i do not want to have to keep change the source
data manually.

D

Andy Pope shows how to do this via te use of dynamic range names here . . .

http://www.andypope.info/charts/piezeros.htm

----
Regards,
John Mansfield
http://www.pdbook.com


"DMc2005" wrote:

Hi

I currently have some data as shown below:

Item 1 0
Item 2 3
Item 3 6
Item 4 5
Item 5 0
Item 6 9

How can I exclude the zero items automatically, the data shown below is
going to change regulary and i do not want to have to keep change the source
data manually.

D

In a pie chart no slice is shown for a zero value, so unlike other chart
types you don't really need to cater for it. Or, do you mean not display
Legend Entries with zero values. That could be done with a macro, though it
would need to be rerun each time values change.

Regards,
Peter T


I currently have some data as shown below:

Item 1 0
Item 2 3
Item 3 6
Item 4 5
Item 5 0
Item 6 9

How can I exclude the zero items automatically, the data shown below is
going to change regulary and i do not want to have to keep change the
source
data manually.

D