LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
WSU Cougar
 
Posts: n/a
Default hiding zero values in stacked bar charts

On a stacked bar chart with values displayed (data label is set to value), I
do not want to display the value if its zero (no slice of data). Is there a
way to do this?

When I have approached different Excel users with this problem, they said
they go back to the spreadsheet and delete the zero's so they do not show up
on the chart.
I have a lot of entries and frequently use the spreadsheet so I want to
avoid having to manually delete the zeros for display purposes.

Thank you.
 
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
Hiding zero values Peppi Excel Worksheet Functions 3 January 8th 06 01:31 PM
Negative or zero values cannot be plotted correctly on log charts NTE Charts and Charting in Excel 6 December 11th 05 05:27 AM
Pivot Charts, hiding field values in second level filters? elrao Charts and Charting in Excel 1 June 17th 05 10:19 AM
Stacked Charts w/ Vertical Separation Stacey Charts and Charting in Excel 1 June 10th 05 07:35 PM
Hiding repeated values jake Excel Discussion (Misc queries) 2 April 27th 05 11:32 AM


All times are GMT +1. The time now is 12:07 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"