I have an Excel worksheets with numerous charts on it. And instead of having the y axis minimum equal 0 I would like them all to equal say 1,500. Is there anyway to do this all at once for all of the charts instead of going into every single chart individually and changing it that way??
Only by create a macro do set the value of the active chart
is there anyway you could elaborate a little more??
It is not possible to adjust the scales min/max value for more than 1 chart at a time. If you have xl2003 or older you can use the F4 key to repeat the application of scale values but you will still need to locate and select the scale of each chart individually.
With code you can loop through the sheet, charts, chartobjects and apply the scale settings.
There are examples on the forum of looping through workbooks for charts and applying settings.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks