Hi,
I have an engineering application with 3 graphs on one spreadsheet. The
horizontal scale varies form +/- 5 to +/- 50 and I need to change the scale
often.

Is ther some code where I can either enter a single value on the spreadsheet
that sets the plus and minus limits on the horizontal scale with one cell
change? So I would enter 25 and the scale would be changed to +25 to -25 on
all 3 graphs?

Thanks
Ted

http://peltiertech.com/Excel/Charts/...nkToSheet.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"TedT" <(E-Mail Removed)> wrote in message
news:E9EC60A2-BBC4-42A6-80AD-(E-Mail Removed)...
> Hi,
> I have an engineering application with 3 graphs on one spreadsheet. The
> horizontal scale varies form +/- 5 to +/- 50 and I need to change the
> scale
> often.
>
> Is ther some code where I can either enter a single value on the
> spreadsheet
> that sets the plus and minus limits on the horizontal scale with one cell
> change? So I would enter 25 and the scale would be changed to +25 to -25
> on
> all 3 graphs?
>
> Thanks
> Ted