I'm trying to create a pie in pie chart. The main pie chart is supposed to break out the grand total of orders, revenue, and profit for the year. Each of these three categories is then supposed to be split into three separate secondary pie charts.
In these secondary pie charts, it must break out how much each of the six employees contributed to orders, revenue, and profit.
So basically this chart will have a primary pie chart summarizing grand totals of orders, rev, and profit. For orders, it will have a secondary pie chart showing how much of the total orders each of the six employees contributed, for revenue it will have its own secondary pie chart that will do the same, same goes for profit.
I'm not sure how to go about doing this. I attached a table showing what my spreadsheet looks like thus far. Thanks in advance for the help!
Bookmarks