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/
_______
"WA" wrote in message
...
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" wrote:
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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______
"WA" wrote in message
...
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.