TLDR: Macro to read 10 views from AOO BASE database and display as 10 charts "en echelon" on first spreadsheet.
Run through a master table containing colours and text for each account (1 to 10) and for each account collect data from a View ending in 1 to 10.
This is to provide an easy visual presentation of cash flows. I am stuck on only showing two charts as follows.
I've got a series of views established as sources to an OO spreadsheet. Every time I open the spreadsheet I have to activate the data source and import from each view into its own pair of columns which provide the source to its appropriate chart. There are 10 of these views.
I'm working on creating a macro to do this.
The end result will be a spreadsheet with a chart for each view on the first sheet, a list of view parameters on the second, and the data loaded from each view on sheets 3 to 10.
I can manage to load the data for sheets 3-10 but am getting stuck on the chart. My current code for the chart aims at drawing the 10 charts on sheet 1 but it only draws 2 charts, *partially - no dataset lines* and then halts with "IndexOutOfBoundsException.. DataSeries index invalid".