Macro in Excel 2010

[wims]

Hi,
Perhaps someone can help me with this:
In Excel 2003, I've created a macro that automatically sets the minimum and maximum Y-axis scale in a bar chart, based on a calculated cell in the sheet.
below is the macro: FL_REGION is the name of the graph, FL_REGION_MIN is the named cell for the minimum, FL_REGION_MAX is the named cell for the maximum.

ActiveSheet.ChartObjects("FL_REGION").Activate
ActiveChart.Axes(xlValue).Select
With ActiveChart.Axes(xlValue)
ActiveChart.ChartArea.Select
.MinimumScale = ActiveSheet.Range("FL_REGION_MIN").Value
.MaximumScale = ActiveSheet.Range("FL_REGION_MAX").Value
End With

Unfortunately, in Excel 2010, the Y-axis is not adjusted anymore, it keeps the original numbers.

Anyone any idea how I should change the macro?
Thanks.
Wims

 

[Trevor G]

Welcome to the Forum,

If you recorded a macro to adjust this what does the results tell you?

 

[wims]

Trevor,
thanks.
I'm not quite sure, but I believe this cannot be recorded. Changing scales cannot be entered by referrinng to a named range, at least I haven't found a way to do that.
Wims

 

[RoryA]

I've just tested your code in 2010 and it works to adjust the scales.
If your workbook was originally created in 2003, you might try recreating the chart in 2010 and see if the code works then.