PC Review


Reply
Thread Tools Rate Thread

Charting only non-zero series

 
 
travis
Guest
Posts: n/a
 
      15th Dec 2005
I often do pie charts from which I need to delete a number of lables
because that particular value is zero, and I don't want the zero series
included in the pie.

What would be an easy way to get Excel to chart only the values which
are not zeros?

Travis

 
Reply With Quote
 
 
 
 
Pete
Guest
Posts: n/a
 
      15th Dec 2005
The way I do it is to have the labels in a column next to the values
and to have a filter covering the values. Apply a Custom filter for
Does Not Equal 0 (zero) - this hides the zero values and lables and the
pie charts automatically adjust.

Pete

 
Reply With Quote
 
travismorien@yahoo.com
Guest
Posts: n/a
 
      15th Dec 2005
Thanks Pete!

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Charting the Sum of Two, or More, Series of Data MJ Microsoft Excel Charting 6 22nd Apr 2010 05:06 PM
Charting - bubble series Darin Kramer Microsoft Excel Programming 4 14th Jun 2007 05:11 PM
Re: Charting Multiple Series? Debra Dalgleish Microsoft Excel Charting 0 29th Mar 2005 07:15 PM
charting series pj Microsoft Excel Programming 2 8th Mar 2005 02:41 PM
Re: Charting a series dvt Microsoft Excel Charting 1 29th Aug 2003 07:49 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:01 AM.