Thread: Chart Help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier[_7_] Jon Peltier[_7_] is offline
external usenet poster
 
Posts: 115
Default Chart Help

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