LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
klp klp is offline
external usenet poster
 
Posts: 13
Default do not show zeros in pivot chart (pie chart)

Is there anyway to suppress the zeros in a pivot chart? My pivot table shows
activities for many different queues, and sometimes a particular queue won't
have a value for an activity that another queue has. When i chart just this
queue, the activity shows up as 0%. I don't want to delete the label, because
then when i change to another queue that DID have that activity, the value
won't show up.

Any thoughts?
thanks!
~klp

 
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
do not show zero's in pivot chart klp Excel Discussion (Misc queries) 1 July 19th 07 08:38 AM
suppress zeros in a pivot chart klp Excel Discussion (Misc queries) 0 July 18th 07 02:56 PM
Show Filters on an Pivot Chart druid Charts and Charting in Excel 0 July 3rd 07 12:30 AM
Pivot Chart - show 1 row value, but also showing percentage of who NewChris Charts and Charting in Excel 0 August 30th 06 07:54 PM
Show stdev errorbars on pivot bar chart Pieter Charts and Charting in Excel 1 April 5th 06 05:55 PM


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