| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamically Scale Gantt Chart Time Scale | Charts and Charting in Excel | |||
| Sum with limits | Excel Discussion (Misc queries) | |||
| Using "if" function to translate 100 scale into 4.0 scale | Excel Worksheet Functions | |||
| How to draw chart: log scale on X axis, natural scale on y axis? | Charts and Charting in Excel | |||
| Limits | Excel Discussion (Misc queries) | |||
Linear Mode
