View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.charting,microsoft.public.excel.misc,microsoft.public.excel.programming
DMc2005 DMc2005 is offline
external usenet poster
 
Posts: 14
Default Zero Values in a Pie Chart

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