I see no solution here outside of VBA. I guess the OP is wanting all the hundreds of charts because of some type of report.

Any ideas?

https://www.excelforum.com/excel-cha...ml#post5808789