How to chart security indices?

[Marcus Leon]

Hi, I have four columns each containing values for different stock
securities. I would like to chart these columns in a line chart with a
line for each column. But I would like to chart the index value as
opposed to the actual value. Does anyone know how to do this?

By index value I mean (1 + ((CurrVal - StartVal) / StartVal) * 1000)
where 1000 is the base index value.

Or if anyone knows of a more clever approach to measuring percent price
changes please let me know.

Thanks!

 

[Jon Peltier]

Marcus -

Assuming your dates are in column A and your stock prices in B:E, you would put
formulas in columns F:I to compute the indexes for these stocks. Now select the data
in columns A and F:I (hold CTRL to add another area to the first), and run the chart
wizard.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______