Hi
I'm trying to do some charts in excel - where I have loads of data on one sheet and thus have to generate at least 15 charts on one sheet. There are 20 tabs so I also have to do charts on those as well. It will take forever to do it one by one, so I was wondering is there some kind of macro I can come up with which will allow me to make several charts at once?

Thanks for your help,
Vbg.

I'm not a charting wiz, perhaps one of our other gentlemen here is. But I do know several absolute Charting "marvels". Those guys are available here:

Excel Charting - Excel Help Forum

My apologies for recommending another forum for this particular question, no offense is intended.