Setting axis labels
Thinking that I need to look at the values from a Range instead of a
String, I tried this
Dim xVal As String
Dim xValRng As Range
-code to setup xVal
results in = B!$H$1,B!$L$1,B!$P$1,B!$T$1,B!$X$1,B!$AB$1,B!$AF$1 ,B!$AJ
$1,B!$AN$1
Set xValRng = Range(xVal)
.SeriesCollection(1).XValues = xValRng.Value
this returns the value but only from the first cell in the range.
a little information gathering:
Debug.Print xValRng.Address
= $H$1,$L$1,$P$1,$T$1,$X$1,$AB$1,$AF$1,$AJ$1,$AN$1
Debug.Print xValRng.Value
= IMP_100_Hz (value of H1)
so why only the first value and not all of them?
More importantly how do I return all of them?
Any help will be appreciated
Robert
On Dec 12, 6:36*pm, Robert H wrote:
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!
|