Thread: percentages

I am charting a figure from January and I would like to have each month's
subsequent figure as a percentage of January's. Is there any way to do
this in a chart without having to have it as a formula in the spreadsheet?

Hi,

You will have to use formula to calculate the values.

That said you can use a named range to do the calculation and plot the data.

Assuming data in cells A1:A5 add this named range.
ChtData: =(Sheet1!$A$1:$A$5/Sheet1!$A$1)

Create a chart and set the values to use this named range. First point
will be 100% others will be a percentage of the first point.

Here are some explanations of using named ranges.
http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/ne...rts/index.html
http://www.stfx.ca/people/bliengme/E...ps/Dynamic.htm

Cheers
Andy

Mark Scott wrote:
> I am charting a figure from January and I would like to have each month's
> subsequent figure as a percentage of January's. Is there any way to do
> this in a chart without having to have it as a formula in the spreadsheet?
>
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info