2 Data Sets on Pie Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to show our brand shares AND the share change vs. previous year
in a pie chart. I can show the percentage (share), but I haven't been able
to add the share pt change to each piece of pie. I tried using secondary
axis on the pie chart, but it charted the changes instead of associating it
with the share axis. I'm using Excel 2002. Currently, I'm linking text
boxes to the share point change for each of the 5-10 brands, but that's
getting really messy, and I have to manually move the text boxes every month.

Can this be done? Any help is appreciated.
 
Patrick -

How would you show two different types of data in the same pie chart? And how do you
represent share changes, when they don't necessarily add to 100%, and aren't all
positive.

I think you'd have a more readily understandable chart if you make a stacked column
chart. Two categories, last year and this year, and each brand is a series. You can
either use a stacked 100% chart, so you can see changes in percentages, or a simpler
stacked chart, so you can see changes in the values of each and of the total.

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