Thread: My dataset contains units; I want to chart percentages

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?

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
_______


"jkyte" <jkyte@discussions.microsoft.com> wrote in message
news:D7137657-59DD-4758-B74D-33EB32C2AAD1@microsoft.com...
>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?