ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Pie chart break down (https://www.excelbanter.com/charts-charting-excel/225986-pie-chart-break-down.html)

Qem

Pie chart break down
 
Hi,

In excel there is an option where you can have a small section of a pie
chart, expanded into a bar. (Bar of pie or Pie or Pie).

Is there a way to have that bar show the break down of a particular section?
I haven't been able to figure out how to have the bar represent multiple
values, that total the section it is pulled out from.

Or is there some other way to prepresent this?

A rough example of what I would like to chart
Basically:

Pie = Total Pets = 500
Section of Pie = Dogs = 10
Bar of Pie = Break down of dogs (2 poodles, 6 mutts, 2 german shepards)

Where I would like to show the percentage of dogs to total pets, but also
have a small comparitive breakdown of the dog breeds.


All times are GMT +1. The time now is 07:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com