chart x axis labels show up as range

R

Robert H

In chart creating code I am trying to set the x-axis values using:

..SeriesCollection(1).XValues = xVal

xVal is a declared range that is basically an array of specific column
headings selected from many. xVal is also used to choose the data
columns used in the chart.

When the chart is generated the x axis labels are the actual range
values "B!$H$1, B!P$1, etc" I need the labels to be the actual values
from the cells.

this seems a simple thing but it eludes me!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting axis labels 5
Setting chart Xvalue errors 5
Charts Having X Axis Scaled Using Calendar Weeks 4
Displaying series list from each chart sheet in workbook 5
X-axis values in xlLine chart problem 3
create chart with column axis 10
Series XValues, determine if labels or values 5
Automatically selecting active chart 4

Top