Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 7th 09, 07:35 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: May 2008
Posts: 204
Default Hide zero entries from legend

I have a pie-chart which refers to 50 rows of data. There are never any more
than 5 or 6 with any values, and the pie chart looks fine... EXCEPT... the
legend shows all 50 entries. Is there a way to tell it to ignore (or not
display) any entries that have a zero value (and therefore do not show in
the pie)?

Thanks

M


  #2   Report Post  
Old August 7th 09, 08:43 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,489
Default Hide zero entries from legend

Hi,

You could use autofilter to hide the rows of those with a zero value.
Or formula as described here,
http://www.andypope.info/charts/piezeros.htm

Cheers
Andy

Michelle wrote:
I have a pie-chart which refers to 50 rows of data. There are never any
more than 5 or 6 with any values, and the pie chart looks fine...
EXCEPT... the legend shows all 50 entries. Is there a way to tell it to
ignore (or not display) any entries that have a zero value (and
therefore do not show in the pie)?

Thanks

M


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #3   Report Post  
Old September 7th 15, 05:06 PM
Junior Member
 
First recorded activity by ExcelBanter: Sep 2015
Posts: 1
Default

Hi Andy

I'm struggling with a similar issue; My data is in the following format ideally I'd like to utilise the answer, but think I've hit the limit of my technical ability....any ideas?

Ans 1 Ans 2 Ans 3
WG1 0 1 2
WG2 2 1 0
WG3 1 0 2




Quote:
Originally Posted by Andy Pope View Post
Hi,

You could use autofilter to hide the rows of those with a zero value.
Or formula as described here,
http://www.andypope.info/charts/piezeros.htm

Cheers
Andy

Michelle wrote:
I have a pie-chart which refers to 50 rows of data. There are never any
more than 5 or 6 with any values, and the pie chart looks fine...
EXCEPT... the legend shows all 50 entries. Is there a way to tell it to
ignore (or not display) any entries that have a zero value (and
therefore do not show in the pie)?

Thanks

M


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


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
Can I ungroup legend entries? Orhan Charts and Charting in Excel 1 January 2nd 06 01:10 PM
Sort Legend Entries Coolboy55 Charts and Charting in Excel 1 August 28th 05 01:27 AM
Chart Legend Entries BillCPA Excel Discussion (Misc queries) 1 July 27th 05 11:32 PM
Legend Entries nelly Charts and Charting in Excel 2 June 30th 05 01:22 PM
Specifying Legend Entries Joey Chart User Charts and Charting in Excel 1 June 23rd 05 12:34 AM


All times are GMT +1. The time now is 04:41 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017