Change Number Of Series On A Chart

[TimTDP]

Last problem and then I am done with this project!
It has come out superbly, and I must thank all that have assisted me.

I use a table as the row source for my chart.

If I add extra fields to the table, how do I get the new fields to automatically display as new series on the chart?

I have tried:
DoCmd.OpenReport ReportName, acViewDesign
Reports!rptGraph.graph0.RowSource = "tblData"

and

With Rpt(graph0)
.RowSource = "tblData"
.ColumnCount = 4
End With

but these don't work!

 

[SpentGeezer]

recordsource perhaps?

 

[TimTDP]

I think that I need to add each series using vba:
.SeriesCollection(i).Add

but I can't get it to work!