Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I have 36 legend entries but only need the ones actualy graphed
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. |
#2
|
|||
|
|||
Hi,
Have a look at this example. http://www.andypope.info/charts/piezeros.htm Cheers Andy Simon wrote: 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. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
Thankyou, I'll give that a try.. cheers!
"John Mansfield" wrote: Here are a couple of resources that will show you how to achieve this: Andy Popes 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/exce...o_zero_values/ ---- Regards, John Mansfield http://www.pdbook.com "Simon" wrote: 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. |
#4
|
|||
|
|||
Here are a couple of resources that will show you how to achieve this:
Andy Popes 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/exce...o_zero_values/ ---- Regards, John Mansfield http://www.pdbook.com "Simon" wrote: 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. |
#5
|
|||
|
|||
One possibility would be to hide the rows with Zero in them. The charts only
show visible cells. "Simon" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
valadation for dropdown won't allow enough entries | Excel Discussion (Misc queries) | |||
How do I change multi-line entries to single line entries in Exce. | Excel Worksheet Functions | |||
count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions | |||
Remove Legend Series | Charts and Charting in Excel | |||
How do I change the order of the legend entries? | Charts and Charting in Excel |