I have a worksheet where I produce a Profit Plot which consists of 125 points in the Series.

I have 10 Scenarios to try: all combinations of numbers 1 to 5 and letters A and B: 1a, 2a, ..., 5a, 1b, ...

I want to generate plots for each of the Scenarios but I am limited to 32 points so I must pick every 5th point of the 125 I wish to plot. While this is acceptable it is a PITA if I manually pick those points for the Scenario Report (SR).

It seems that to recalculate, I have to create another SR which is a pain.

QUESTION: Any clever way to make this recalculation easy? I guess I could record a MACRO when I create the SR but that is a bit of a kludge.

OR maybe just use a Table?

Since I need only 125 points, I could build a Table with 125 columns. Of course the output cells are actually a Column w/125 rows and I would have to transpose those into a Row in the Table.

Maybe I've just answered my question....?