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