| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing the secondary y axis scale values
Ken,
ActiveChart.Axes(xlValue, xlSecondary).Select With ActiveChart.Axes(xlValue, xlSecondary) .MinimumScale = ymin .MaximumScale = ymax .MinorUnitIsAuto = True .MajorUnit = yunit .CrossesAt = 0 .ScaleType = xlLinear End With Pick and choose what you want. Watch the variables. (You can get this code by using the macro recorder) -- sb "Ken Ramirez" wrote in message ... Does anyone know how to Reference the Seconday Y axis scale values in code? I am automating a spreadsheet that uses a chart and i need to adjust these values at run time. I'm using Visual Basic. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart - Secondary Y-axis with different values/scale | Charts and Charting in Excel | |||
| Re scale primary and secondary y axis using sliders request | Charts and Charting in Excel | |||
| On a secondary Y-axis, scale values are repeated: 1, 1, 2, 2. | Charts and Charting in Excel | |||
| How to make Primary axis and Secondary X-axis have the same scale | Excel Discussion (Misc queries) | |||
| secondary axis scale | Charts and Charting in Excel | |||
Threaded Mode
