Prev: Using a cell's value in a macro command
Next: Spontaneous format changes in Excel
From: Dave on 20 Nov 2009 08:44
Hi, I am tring to make a pie chart that needs to include 2 pieces of
information for one series.

I have two columns of information (number and value) that relate to one
person. There are 5 people all together.

How do I do this?
From: Luke M on 20 Nov 2009 08:57
Technically possible, you might create a bar-pie chart or a pie-of-pie chart.
IMO, this would be a TERRIBLE idea. Pie charts should be forgotten, IMO,
because they often distort data and make it very hard to actually read the
data.
http://peltiertech.com/WordPress/whats-worse-than-a-pie-chart/

My recommendation would be to make a clustered chart, a stacked-column
chart, or perhaps a clustered-stacked chart.
http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Dave" wrote:

> Hi, I am tring to make a pie chart that needs to include 2 pieces of
> information for one series.
>
> I have two columns of information (number and value) that relate to one
> person. There are 5 people all together.
>
> How do I do this?
 | 
Pages: 1
Prev: Using a cell's value in a macro command
Next: Spontaneous format changes in Excel