Log In
Register
Home
June 30, 2020
Offline
I'm creating a chart to show turnover and wanted to display both count and percentage. I calculate the percentage to get the turnover as term count/active count. This formula also creates 100% of the active. Is there a way to hide the percentage for only the active count (100.00%) but display the term percentage?
| Count | Percentage | |
| TERM | 172 | 6.07% |
| FT | 43 | 3.65% |
| LS | 33 | 10.03% |
| PT | 96 | 7.23% |
| ACTIVE | 2834 | 100.00% |
| FT | 1177 | 100.00% |
| LS | 329 | 100.00% |
| PT | 1328 | 100.00% |
| Grand Total | 3006 |
See Answer
July 16, 2010
Offline
Hi Christy,
Welcome to our forum!
Pivot Charts display all data in the PivotTable, you can't pick and choose. However, I can't tell from the example data whether this is supposed to represent a PivotTable or your source data. Can you please upload a sample Excel file showing the PivotTable and chart that you have so I can see what options there are for omitting the 100% calculations.
It may be that you have to resort to the regular chart from a PivotTable solution, but I can't tell until I see the file.
Mynda
Answers Post
1 Guest(s)
