View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Archangel
 
Posts: n/a
Default Possible bug in Excel 2007 with pie charts and 0 values?

Hi guys,

I've found my experiences with Office 2007 great, apart from this annoying
issue:
If i create a pie chart, and one of the data ranges has a zero value, the
whole pie chart becomes the colour of the zero value.
So if i had 3 values, 10, 20, 0, which were coloured green, blue and red
respectively in a pie chart, the whole pie becomes red, instead of two
colours.
this doesnt happen in Excel 2003 (ie: my pie charts have always looked nice).

I understand that people might just say to not include the zero values, but
that doesnt fix the 'problem'.