BiggusDoggus
Board Regular
- Joined
- Jul 7, 2014
- Messages
- 91
- Office Version
- 365
- Platform
- Windows
Hi,
So I have a pivot table, and are using % of Parent Column Total to display the % of 1 & 0's as a % of the total # of both, for individual sellers.
I want to also create a bar chart from this table - but to only display the %'s of 1's.
So, for example, for August I only want to show for each (blacked out) seller, 50%, 50%, 20.41% & 85.71% respectively.
Can I do this please? The chart becomes far too crowded (I have a larger number of sellers than the above), and obviously the focus is completely lost if it includes the 0's % as well (as well as them being pointless).
If I filter out 0's in any way then they get removed from the pivot table altogether, and all the values become 100% for 1's.
So I have a pivot table, and are using % of Parent Column Total to display the % of 1 & 0's as a % of the total # of both, for individual sellers.
I want to also create a bar chart from this table - but to only display the %'s of 1's.
So, for example, for August I only want to show for each (blacked out) seller, 50%, 50%, 20.41% & 85.71% respectively.
Can I do this please? The chart becomes far too crowded (I have a larger number of sellers than the above), and obviously the focus is completely lost if it includes the 0's % as well (as well as them being pointless).
If I filter out 0's in any way then they get removed from the pivot table altogether, and all the values become 100% for 1's.