Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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'.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel spreadsheets with data, Powerpoint charts... and VBA! Petitboeuf Excel Discussion (Misc queries) 1 May 26th 06 11:15 AM
Excel Charts - Missing Values ediamond Charts and Charting in Excel 2 January 18th 06 07:56 PM
hiding zero values in charts fascal Charts and Charting in Excel 4 December 19th 05 02:17 PM
Excel should heavily extend the options for black-white charts Dan from Sweden Charts and Charting in Excel 0 October 17th 05 01:26 PM
Excel Charts Linked to Spreadsheets Rich Charts and Charting in Excel 1 July 4th 05 04:36 PM


All times are GMT +1. The time now is 06:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"