Repeating rows of data and charts multiple times (100+)

Hi Adam

assuming the data ranges are are predictable this is probably possible with a macro, but I'm struggling to see exactly how you want the data to change over time and where new data would be added. To get you started with some ideas maybe copy the first chart to a new sheet and in that sheet run this macro - it should copy the first chart 7 times and replace the source range in the copied charts with each of your "measure" data tables. It relies on the rows and columns being the same distance apart

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

The next step is to copy your existing 8 charts and paste them at regular intervals adjacent to the table sets below:

Please Login or Register  to view this content.

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.

Please Login or Register  to view this content.

good luck!