Normalize Graph

  • Thread starter Thread starter WA
  • Start date Start date
W

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.
 
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
 
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?
 
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?
 
Double click the axis, and on the Patterns tab, choose the Low option for
axis tick labels.

- Jon
 
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
 
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
 
Back
Top