Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting maximum and Minimum Scale for the Category axis
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting the minimum/maximum display range of a chart | Excel Discussion (Misc queries) | |||
Axis Options - Minimum and Maximum Values | Charts and Charting in Excel | |||
How do I automate the minimum and maximum x scale? | Charts and Charting in Excel | |||
Category axis scale | Charts and Charting in Excel | |||
Excel can't execute minimum / maximum scale property | Excel Programming |