Normalize Graph

[WA]

I have the graph of the historical prices of a stock. I was wondering whether
it can be normalized. To clarify, I would like to see a graph with (-1) to
(1) on the y axis and time on the x-axis. The trend line of the stock price
data would be considered zero and the moves above or below that line would be
depicted between -1 and 1.

If anyone knows whether there is a function/graph type in excel to perform
this task, your assistance would be greatly appreciated.

Thanks.

 

[Jon Peltier]

Normalize the data that feeds the chart. To normalize your data to MIN = -1
and MAX = 1, use a formula like this:

=2*(B2-MIN(B$2:B$1000))/(MAX(B$2:B$1000)-MIN(B$2:B$1000))-1

where your data is in B2:B1000, and this formula is to normalize the first
point, in B2.

- Jon

 

[WA]

Thanks for the rapid response John. Thats exactly what I was looking for.

 

[WA]

Thanks.

When I construct the graph, I have the x-axis labels (in this case, dates)
running through the middle of the chart. How do I move them to the bottom of
the chart?

 

[WA]

When I create the chart, my x-axis labels (in this case, dates) run right
through the middle of the chart, along the zero line. How do I move them to
the bottom of the chart?

 

[Jon Peltier]

Double click the axis, and on the Patterns tab, choose the Low option for
axis tick labels.

- Jon

 

[WA]

Great - Thanks Jon

Double click the axis, and on the Patterns tab, choose the Low option for
axis tick labels.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______

 

[dejan]

how does one normalize two or more time series, so as to make them start with
ie 100, or for that mattern any other value?
I would like to see two time series starting from the same point, ie from
the first data point of the first series. On other words, i would like to
normalize one series with another.
How can it be done in excel?
thanks a lot

 

[Mike Middleton]

dejan -

The simplest way to normalize is to divide each value in a time series by
the starting value of the time series (and multiply by 100 if you want an
"index" instead of a percentage).

- Mike
http://www.MikeMiddleton.com