Thanks to Barb for the suggested solution, which I tried. Excel then allowed
me to easily create the 120 charts I wanted on a single worksheet.
However, I also wanted to copy the worksheet several times (within the same
workbook) but wasn't able to copy more than TWICE (i.e. I did get 360 charts
total, plus associated data tables). On the 4th time of trying to copy the
worksheet, the data tables copied ok but the charts did not copy at all.
Interestingly enough, I was able to CREATE at least one new chart on the 4th
worksheet, but with so many charts needed, I didn't want to have to revert to
Although this didn't seem to me like a problem of exceeding a chart number
capacity (if there is such a thing - anyone know????), there did seem to be
some link to the high volume of charts as the problem source. Any help