Setting maximum and Minimum Scale for the Category axis

A

Ayo

I know how to set the xlValue for charts but I am having a problem setting
the xlCategory property. I get and error when I try:
..Axes(xlCategory).MinimumScale
What is the best way to do this?
Thanks.

With Me.ChartObjects("WeeklyChart").Chart
.Axes(xlValue).MinimumScale = minScale
.Axes(xlValue).MaximumScale = maxScale
.Axes(xlValue).MajorUnit = maxScale / 2
.Axes(xlValue).MinorUnit = maxScale / 4
.HasTitle = True
.ChartTitle.Text = Range("B3") & " " & " Actuals - NLP2"
End With
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

controlling chart location 1
Date values not appearing correclty in the x-axis 1
Putting the series 1 and series 2 titles from a worksheet 0
all series on secondary axis 2
reverse axis not working as before... 0
Problem when trying to set axis properties of a chart by VBA 2
Excel automation, change Category (X) Axis Labels, VB6 1
different value for setting with breakpoint vs regular running code 2

Top