I have manually created two sets of charts for two of the "ID" values shown in Column A. They represent example chart data ranges and formatting I'd like to replicate for the remaining IDs (see attached spreadsheet).
I am in need of code that will replicate the set of charts (one chart, one scatter chart) for each unique ID based on the range of values in Column C and D associated with each ID.
The desired result is 8 sets of charts that appear as 3 sets on each of the first two pages and 2 sets on the 3rd page.
For the line chart, the min value of the y-axis is fixed at 10, while the max value of the y-axis is allowed to vary based on the max value of the input y-axis data range. The date range on the x-axis does not vary among the different IDs.
The min/max values for the x- and y-axis of the scatter charts are fixed at 10 and 50 to accommodate all possible values in Columns C and D.
Many thanks in advance for your help.
charts.xlsx
Any help is very much appreciated.