| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding the scale on a chart
I know how to set the scale on a chart with vba code but how would I find
(using vba code) what the scale is set to in a cahrt? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
finding the scale on a chart
Hi,
This will return the maximum value of the value axis. msgbox activechart.Axes(xlvalue).maximumscale Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Scott" wrote in message ... I know how to set the scale on a chart with vba code but how would I find (using vba code) what the scale is set to in a cahrt? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamically Scale Gantt Chart Time Scale | Charts and Charting in Excel | |||
| Chart Scale | Charts and Charting in Excel | |||
| How to draw chart: log scale on X axis, natural scale on y axis? | Charts and Charting in Excel | |||
| Huge differences in chart values screws my bar chart scale up. | Charts and Charting in Excel | |||
| vc++ automation: opening chart as chart window and setting scale | Excel Programming | |||
Linear Mode
