| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Link between values on two axis
Hi,
How can I create a link between values on primary and secondary Y-axis? These values should not be set manually since there are many sheets and the values will cahnge. For example, if I want that the values of left Y-axis (from 0 to 200 and from 0 to 500) are always the values of right Y-axis divided by 2 (from 0 to 400 and from 0 to 1000). |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Link between values on two axis
If you're willing to use macros, you can link the scales to each axis to
worksheet cells. Jon's site provides the code and shows how this can be done. http://peltiertech.com/Excel/Charts/...nkToSheet.html -- John Mansfield http://cellmatrix.net "Waacku" wrote: Hi, How can I create a link between values on primary and secondary Y-axis? These values should not be set manually since there are many sheets and the values will cahnge. For example, if I want that the values of left Y-axis (from 0 to 200 and from 0 to 500) are always the values of right Y-axis divided by 2 (from 0 to 400 and from 0 to 1000). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I reference x-axis or y-axis scale values to a worksheet ce | Excel Discussion (Misc queries) | |||
| How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel | |||
| how to put x axis values in the chart instead of x axis labels | Charts and Charting in Excel | |||
| How do I change X-Axis values in a chart with 2 Y-Axis? | Charts and Charting in Excel | |||
| Hiding Values Below Z Axis Minimum Value on Axis Charts | Charts and Charting in Excel | |||
Linear Mode
