Thread: Chart Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Raul[_4_] Raul[_4_] is offline
external usenet poster
 
Posts: 28
Default Chart Help

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