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.