View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Joe_Hunt via OfficeKB.com Joe_Hunt via OfficeKB.com is offline
external usenet poster
 
Posts: 50
Default Axes on chart in UserForm

I'd tried that before, but it didn't work. Here's the error message I get:

Compile error:
Wrong number of arguments or invalid property assignment.

Any ideas? I'll do a search in the "errors" section.

Jon Peltier wrote:
I don't know OWC's object model, but it's something like Excel's. You need
to access the axis titles through the axis. In Excel it's like:

.Axes(xlCategory, xlPrimary).HasTitle = True
.Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = "X Axis Title"
.Axes(xlValue, xlPrimary).HasTitle = True
.Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = "Y Axis Title"

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

I'm trying, with limited success, to put labels on the charts on both the
X

[quoted text clipped - 63 lines]
End If
End Sub


--
Message posted via http://www.officekb.com