Excelquestion35
Board Regular
- Joined
- Nov 29, 2021
- Messages
- 53
- Office Version
- 2016
- Platform
- Windows
Hi all,
I am trying to make a pie chart which shows the elimination of some volume, based on some criteria volume is lost.
By creating a pie chart I can only find the option to get a pie chart to show all volumes in one pie, however I would like to see a pie chart which shows the total volume 290247 and inside this pie the amount that is left with every criteria. More like a layered pie chart, is such a chart possible?
This is the pie I get when I try it now, but the total pie is the sum of all these volumes combined, while it should be only the 290247.
I am trying to make a pie chart which shows the elimination of some volume, based on some criteria volume is lost.
By creating a pie chart I can only find the option to get a pie chart to show all volumes in one pie, however I would like to see a pie chart which shows the total volume 290247 and inside this pie the amount that is left with every criteria. More like a layered pie chart, is such a chart possible?
| Double single | Block/Euro | Weight | Overhang | |
290247 | 174148 | 140167 | 110284 | 105762 | |
80% | 80% | 79% | 4% |
This is the pie I get when I try it now, but the total pie is the sum of all these volumes combined, while it should be only the 290247.