A
Archangel
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'.
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'.