Graph: show data on secondary axis with VBA

[boerbende]

Dear readers,

I am trying to show the user 2 different lines with different scales.
I would like to show the first as primary and the second line as secondary axis with VBA.
I am using VBA because it could also be 6 colums, where only the 5th is on the secondary axis
I found some code from Excel VBA I am trying to use

with graph47
SQLstr = string to get date + 2 columns

.rowsource = SQLstr

.SeriesCollection(2).AxisGroup = xlsecondary
.SeriesCollection(2).Format.Line.Visible = True
.HasAxis(xlCategory, xlprimary) = True
.HasAxis(xlCategory, xlsecondary) = True
.HasAxis(XlValue, xlprimary) = True
.HasAxis(XlValue, xlsecondary) = True
.Axes(xlCategory, xlprimary).CategoryType = xlautomatic
.Axes(xlCategory, xlsecondary).CategoryType = xlautomatic

however, this does probably work for Excel, but Access does not know xlcategory, xlvalue, xlautomatic etc
Anybody knows how set my secondary column to the secondary axis?

Many thanks

Ben