R
Robert H
In chart creating code I am trying to set the x-axis labels using:
..SeriesCollection(1).XValues = xVal
xVal is a declared string that is basically an array of specific
column
headings selected from many.
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!
..SeriesCollection(1).XValues = xVal
xVal is a declared string that is basically an array of specific
column
headings selected from many.
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!