Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,582
Default Code to change graph scales

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" wrote in message
...
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
equations on appropriate graph scales Jon Excel Discussion (Misc queries) 0 November 15th 08 08:43 AM
bar graph with varying Y scales [email protected] Charts and Charting in Excel 3 September 14th 06 11:14 PM
how can i graph with log-log scales? AirdromeTom Charts and Charting in Excel 1 December 15th 04 05:06 PM
how can i graph with log-log scales? AirdromeTom Charts and Charting in Excel 1 December 15th 04 04:34 PM
Graph with two scales - calling a graph expert ! Steve P[_3_] Excel Programming 1 September 11th 03 01:12 PM


All times are GMT +1. The time now is 11:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"