Hi John,
in my opinion 30 seconds is quite possible. It depends on your machine
too. I used to work with workbooks taking even few minutes to be
recalculated.
I guess pivot tables could be faster, especially if your charts are
similar to each other and could be based on one pivot table. The best
way is to give it a try.
Wish you luck!