I have 36 legend entries but only need the ones actualy graphed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a pie graph created from 36 rows by 1 numeric 'count' column. I have
created a pie chart which shows the count distribution based on the 36 rows.
Where a row has zero count, there is no slice. I would like to turn off the
legend entry automatically where a row has a zero count, thereby reducing the
overall size of the legend table.
 
Thankyou, I'll give that a try.. cheers!

John Mansfield said:
Here are a couple of resources that will show you how to achieve this:

Andy Pope’s site – includes a downloadable example:

http://www.andypope.info/charts/piezeros.htm

The example in the hyperlink below also includes a downloadable file. The
chart in the example is a clustered column type. For your needs, change the
type to a pie chart. Then, in the Standard Toolbar go to Chart -> Chart
Options -> Legend Tab. Check the Show Legend option.

http://www.pdbook.com/index.php/excel/omitting_x_axis_labels_tied_to_zero_values/
Click to expand...
 
Here are a couple of resources that will show you how to achieve this:

Andy Pope’s site – includes a downloadable example:

http://www.andypope.info/charts/piezeros.htm

The example in the hyperlink below also includes a downloadable file. The
chart in the example is a clustered column type. For your needs, change the
type to a pie chart. Then, in the Standard Toolbar go to Chart -> Chart
Options -> Legend Tab. Check the Show Legend option.

http://www.pdbook.com/index.php/excel/omitting_x_axis_labels_tied_to_zero_values/
 
One possibility would be to hide the rows with Zero in them. The charts only
show visible cells.
 
Back
Top