pie chart question.....

Please can someone help me with a special pie chart that I need to prepare.
The chart will be used as a visual indicator of a sales mix and will be
updated over time to show trends.

To explain my idea, I will use cars as the example:

Let's say that we sell 4 types of car:

FORD
TOYOTA
BMW
MERCEDES

Overall, I want the pie to represent the total sales value whilst showing
the split of sales (% or value label) by make of car, eg FORD etc.
In these large slices of the pie, I would like to use a different colour
(for each type of car)

However, and here (for me, anyway) comes the difficult bit..

Let's say that within each car range, I want to show the different colours
that were sold.
So, for each segment of the pie (percentage of FORD etc.) I would like to
sub-divide into colours that were sold, eg. Ocean Blue, Steel Grey etc..
This would then show me clearly:
A) Which make of car is selling best
And
B) Which colour - within each make - is most popular


I would be very happy if I could achieve the above. But if it were possible,
I would also like to arrange each of the sub-divisions for colour from
largest to smallest within each large (make of car) section of the pie

I have been fairly successful in creating various charts in excel over the
years, but pie charts are not my speciality, so any help or suggestions
would be very much appreciated.

Many thanks,
Paul (UK)

As the first option, I would take a look at Jon Peltier's Pie of Pie example:

http://pubs.logicalexpressions.com/P...cle.asp?ID=471

As the second option, have you considered using a doughnut chart? For
example, you could set your data up like this:

Ford 3 15
5
7
Toyota 7 21
5
9

The second column is the individual breakouts. The third column consists of
the total sales. Choose the doughnut chart from the chart wizard. You'll
have to do some formatting changes to the legend, etc. to make it look like
you want.

----
Regards,
John Mansfield
http://www.pdbook.com


"Spam Trap" wrote:

> Please can someone help me with a special pie chart that I need to prepare.
> The chart will be used as a visual indicator of a sales mix and will be
> updated over time to show trends.
>
> To explain my idea, I will use cars as the example:
>
> Let's say that we sell 4 types of car:
>
> FORD
> TOYOTA
> BMW
> MERCEDES
>
> Overall, I want the pie to represent the total sales value whilst showing
> the split of sales (% or value label) by make of car, eg FORD etc.
> In these large slices of the pie, I would like to use a different colour
> (for each type of car)
>
> However, and here (for me, anyway) comes the difficult bit..
>
> Let's say that within each car range, I want to show the different colours
> that were sold.
> So, for each segment of the pie (percentage of FORD etc.) I would like to
> sub-divide into colours that were sold, eg. Ocean Blue, Steel Grey etc..
> This would then show me clearly:
> A) Which make of car is selling best
> And
> B) Which colour - within each make - is most popular
>
>
> I would be very happy if I could achieve the above. But if it were possible,
> I would also like to arrange each of the sub-divisions for colour from
> largest to smallest within each large (make of car) section of the pie
>
> I have been fairly successful in creating various charts in excel over the
> years, but pie charts are not my speciality, so any help or suggestions
> would be very much appreciated.
>
> Many thanks,
> Paul (UK)
>
>
>
>

Another option would be the Matrix chart:

http://pubs.logicalexpressions.com/P...cle.asp?ID=508

In the next to last chart on the page, imagine the automobile make
across the bottom, and the color up the side.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

John Mansfield wrote:

> As the first option, I would take a look at Jon Peltier's Pie of Pie example:
>
> http://pubs.logicalexpressions.com/P...cle.asp?ID=471
>
> As the second option, have you considered using a doughnut chart? For
> example, you could set your data up like this:
>
> Ford 3 15
> 5
> 7
> Toyota 7 21
> 5
> 9
>
> The second column is the individual breakouts. The third column consists of
> the total sales. Choose the doughnut chart from the chart wizard. You'll
> have to do some formatting changes to the legend, etc. to make it look like
> you want.
>
> ----
> Regards,
> John Mansfield
> http://www.pdbook.com
>
>
> "Spam Trap" wrote:
>
>
>>Please can someone help me with a special pie chart that I need to prepare.
>>The chart will be used as a visual indicator of a sales mix and will be
>>updated over time to show trends.
>>
>>To explain my idea, I will use cars as the example:
>>
>>Let's say that we sell 4 types of car:
>>
>>FORD
>>TOYOTA
>>BMW
>>MERCEDES
>>
>>Overall, I want the pie to represent the total sales value whilst showing
>>the split of sales (% or value label) by make of car, eg FORD etc.
>>In these large slices of the pie, I would like to use a different colour
>>(for each type of car)
>>
>>However, and here (for me, anyway) comes the difficult bit..
>>
>>Let's say that within each car range, I want to show the different colours
>>that were sold.
>>So, for each segment of the pie (percentage of FORD etc.) I would like to
>>sub-divide into colours that were sold, eg. Ocean Blue, Steel Grey etc..
>>This would then show me clearly:
>>A) Which make of car is selling best
>> And
>>B) Which colour - within each make - is most popular
>>
>>
>>I would be very happy if I could achieve the above. But if it were possible,
>>I would also like to arrange each of the sub-divisions for colour from
>>largest to smallest within each large (make of car) section of the pie
>>
>>I have been fairly successful in creating various charts in excel over the
>>years, but pie charts are not my speciality, so any help or suggestions
>>would be very much appreciated.
>>
>>Many thanks,
>>Paul (UK)
>>
>>
>>
>>