My dataset contains units; I want to chart percentages

[jkyte]

I am preparing a presentation in Powerpoint. My slides contain line charts.
I want the dataset to be shown and reflect actual units and the graph to
reflect percentages. For example, in period 1, customer purchased 80 units of
Brand A and 20 units of Brand B; therefore, in period 1 Brand A represents
80% of customer's purchases and brand B represents 20%. In period 2,
customer purchased 150 units of Brand A and 50 Units of Brand B. Therefore,
although the number of Brand A units sold increased by 70 units from period 1
to period 2, Brand A's market share declined from 80% to 75%). I wish to
graph the market share changes while displaying the actual unit sales below
the chart. Can this be done?

 

[Jon Peltier]

Compute the percentages in another range, and use these calculations in your
chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______