When using Excel in Microsoft 2000 - I want to create a macro that will
produce a pie chart for 2 rows of data in column B and then repeat this for
columns C, D, E etc. until there is no longer any data. The labels are in
column A.

To get the base code, turn on the macro recorder, create the pie chart
by hand, and turn off the recorder. XL will give you the necessary
code, which can then be customized and generalized. If you don't know
how, share the code you have and someone should be able to help you out.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article ,
says...
When using Excel in Microsoft 2000 - I want to create a macro that will
produce a pie chart for 2 rows of data in column B and then repeat this for
columns C, D, E etc. until there is no longer any data. The labels are in
column A.