If you set the axis options to auto, then it will adjust to suit your data,
but it will do it in the way it wants, which isn't necessarily the way you
would prefer it.
--
David Biddulph

"Phil Smith" wrote in message
...
Thanx, but that is not going to cut it for this project. I need the axis
to change based on the data it is presented. Updating the data should
update the chart, including the axis. Both the X and Y axis may change by
a couple of orders of magnitude between runs. Having to go in manually
and change that each time, (currently expected to be more than twenty
times per day,) is just not feasible.

I thought the whole power of a spreadsheet was to automatically adjust
everything revolving around the data as the data is changed.

Got anything else?

Thanx
Phil




Gerigto wrote:
You should be able to click on the specific axis, then right click and
format axis. Under Scale, you should be able to change the axis range.