percentages

[Mark Scott]

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]

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/newsgroups/dynamic_charts/index.html
http://www.stfx.ca/people/bliengme/ExcelTips/Dynamic.htm

Cheers
Andy