scotthannaford1973
Board Regular
- Joined
- Sep 27, 2017
- Messages
- 110
- Office Version
- 2010
- Platform
- Windows
Hi
I have a basic pie chart which uses a pivot table as a source, and slicers that then affect what the chart shows. So for example - the unfiltered pie chart:
and with a slicer applied, there's then only one value shown in the chart, but the filtered options still show on the chart as value = 0
Is there a way in either the pie chart config, or using VB, so that the chart only shows values and labels greater than 0? i.e. so the filtered categories don't appear on top of each other and look rubbish!
EDIT:
sorry - and let's say the chart is called "Chart14"
I have a basic pie chart which uses a pivot table as a source, and slicers that then affect what the chart shows. So for example - the unfiltered pie chart:
and with a slicer applied, there's then only one value shown in the chart, but the filtered options still show on the chart as value = 0
Is there a way in either the pie chart config, or using VB, so that the chart only shows values and labels greater than 0? i.e. so the filtered categories don't appear on top of each other and look rubbish!
EDIT:
sorry - and let's say the chart is called "Chart14"
Last edited by a moderator:
