MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Setting Chart Axis Captions selects it on each chart


Posted by Ron Dionne on October 25, 2001 1:21 PM

When creating a series of charts, I set the chart axis
titles like so:

With ActiveChart.Axes(xlCategory)
.HasTitle = True
.AxisTitle.Caption = "Unit Number"
End With

When my charts are created, however, the caption is
selected on each chart like I want to resize or move
it. How do I keep this from happening?


Posted by Ron Dionne on October 25, 2001 1:35 PM

I figured it out. Activechart.deselect does the trick.