I am building an Column-Line on 2 Axes chart via Automation from Access.
It is basically working, but for some reason, I can't get it to set the
Category (x) axis labels now.
I am now getting a 1004 "unable to set the CategoryNames property of the
Axis class" error message.
I am setting it with:
Set oXLCAx = oXLC.Axes(xlCategory, xlPrimary)
With oXLCAx
.CategoryNames = xlWS.Range(oXAxis.RangeAddress)
<...snip...
end with

Current, my oXAxis.RangeAddress object is holding the following value:
"[Sheet1]DatarptCorpIncidentsBarsAndLine!$B$2:$B$14,
[Sheet1]DatarptCorpIncidentsBarsAndLine!$B$26,
[Sheet1]DatarptCorpIncidentsBarsAndLine!$B$28,
[Sheet1]DatarptCorpIncidentsBarsAndLine!$B$30:$B$31"

Does it have a problem accepting a non-contiguous address range?
I have previously defines 8 series (4 each on the primary and secondary axes)

....or have I made some other sort of sequence error in creating the
seriescollections? (I found that I had to make a 4 primary series, and add
the 4 secondary ones, doing it pair by pair did not seem to work properly and
the series' wound up getting mixed up on the wrong axes somehow (despite
putting the .axisgroup = xlprimary or .axisgroup = xlsecondary on each series
object)!?

(I also tried to set the .XValues when creating/adding the series with my
oXAxis.Rangeaddress value, and it would not take that either...=1004 error.)

Any suggestions?