View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TedT TedT is offline
external usenet poster
 
Posts: 13
Default Code to change graph scales

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