Hi
this is more complex than i'd though, but this seems to work. It's very unstable and relies on there being exactly 27 rows between the start of each sets of data.
To begin, have a worksheet in which there are only 8 charts - the ones in your first dashboard - but with successive tables in columns B to M as outlined in your sheet. In order for the charts to display properly the combined height of these sub tables must be no less that the height of your first set of dashboard tables. You may want to use this macro to replicate the row heights in the first table group rows in the rows below
The next step is to copy your existing 8 charts and paste them at regular intervals adjacent to the table sets below:
The final step, and the one you're most likely to experience problems with, is to replace the series formulas in each chart below the first 8 with formulas sourcing the data from ranges 27, 54, 81 etc rows below the source ranges in the copied charts.
good luck!
Bookmarks