percentages

[Jen]

I have a chart of prices. I want to make another chart which will show a
percentage of the prices in the first chart. eg. 20% of all the prices.

I have no idea how to start

Please help

Thanks

 

[Pyrite]

Jen,

I presume you have a table in your spreadsheet has a list of prices. I guess
you have then created a chart from this data range so you have a bar chart or
pie chart or whatever type of chart of your prices.

To make a chart of showing a percentage of those prices you just need
another table holding the percentages.

Example:

You have a price of £10.00 in cell A2.
In cell E2 use the formula =(A2/100)*20
This will calculate 20% of any price entered into cell A2.
If your prices ran from A2 to A30 you ould then just copy this formula down
cells E2 to E30 and voila you have a table of of 20% prices.

You could then use this second table as the data source for your chart of
percentage prices in the same way that you did for the first chart of full
prices.

HTH