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 |
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
Mynda, Thank you, glad to be here. I tried the copy and paste and was able to create a chart with just the data I wanted. Thank you for the quick response!
