If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Scale Limits
Hi,
Is it possible to drive the max and mins of a y-axs on a chart from cells S6 and S7 of the same worksheet? This way it updates with changes to data without showing everything. Thanks LiAD |
#2
|
|||
|
|||
Scale Limits
You need a little VBA for this. Here's how:
Link Chart Axis Scale Parameters to Values in Cells (VBA) http://peltiertech.com/Excel/Charts/...nkToSheet.html - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ On 3/26/2010 10:09 AM, LiAD wrote: Hi, Is it possible to drive the max and mins of a y-axs on a chart from cells S6 and S7 of the same worksheet? This way it updates with changes to data without showing everything. Thanks LiAD |
#3
|
|||
|
|||
Scale Limits
Perfect
Thanks "Jon Peltier" wrote: You need a little VBA for this. Here's how: Link Chart Axis Scale Parameters to Values in Cells (VBA) http://peltiertech.com/Excel/Charts/...nkToSheet.html - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ On 3/26/2010 10:09 AM, LiAD wrote: Hi, Is it possible to drive the max and mins of a y-axs on a chart from cells S6 and S7 of the same worksheet? This way it updates with changes to data without showing everything. Thanks LiAD . |
Thread Tools | |
Display Modes | |
|
|