Thread: How to write macro to set the chart scale min/max property?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Troubled Troubled is offline
external usenet poster
  
Posts: 10
Default How to write macro to set the chart scale min/max property?
I have been trying to set the minimum and maximum values for the value axis
in Chart1 using macros without success.

The Help file mentioned below VBA but I tried and it doesn't work. Maybe I
missed out writing some steps.

With Charts("Chart1").Axes(xlValue)
.MinimumScale = 10
.MaximumScale = 120
End With

Anyone can help me??? Many Thanks.


Reply With QuoteReply With Quote