Jon,
The commands were in the same order but the chart types
were different. The ChartType was xlLineMarkers in the
code that worked, and xlSurface in the code that didn't.
Thanks to your suggestion, I was able to work around the
problem by creating the chart with ChartType =
xlLineMarkers and assigning the XValues and then changing
the ChartType to xlSurface as one of the last steps.
I know it isn't a terribly elegant solution, but it is
reasonably effective.
I appreciate the suggestions.
Thanks again,
Raul
-----Original Message-----
Raul -
That's not really enough code to allow a diagnostic.
Does your other
routine create the same chart type? Are the commands in
the same order?
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Raul wrote:
I have a routine which prompts a user for several
ranges
of data (one range is for the data and the other range
is
for the x-axis labels) to chart and then creates a 3D
surface chart. The problem is I cannot set the
chart's
Category (X) axis labels.
The chart object is called NewChart, and I get
an "Unable
to set the XValues property of the series class" error
when I use
NewChart.SeriesCollection(1).XValues = XValRange
to set the category (X) axis labels.
The odd thing is I use the same methodology in another
routine which is working.
Any suggestions?
Thanks,
Raul
.