Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
value of chart scaling
how can I retrieve the value of the max and min scaling in
the active chart? I'd like to set variables equal to each? Thanks }:-) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
value of chart scaling
does this help?
bottom=yourvalue top=yourvalue ActiveChart.Axes(xlValue).Select With ActiveChart.Axes(xlValue) .MinimumScale = bottom .MaximumScale = Top .MinorUnitIsAuto = True .MajorUnitIsAuto = True ' .MajorUnit = 500 .Crosses = xlAutomatic .ReversePlotOrder = False .ScaleType = xlLinear .DisplayUnit = xlNone End With ActiveChart.Deselect -- Don Guillett SalesAid Software "Paul" wrote in message ... how can I retrieve the value of the max and min scaling in the active chart? I'd like to set variables equal to each? Thanks }:-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Chart Scaling | Charts and Charting in Excel | |||
Scaling within a chart | Charts and Charting in Excel | |||
Scaling the x-axis on a line chart | Charts and Charting in Excel | |||
2 Axis chart and scaling | Charts and Charting in Excel | |||
Chart Scaling | Excel Programming |