try Jon Peltier and Tushar Mehta's webpages

http://www.tushar-mehta.com/index-old.html
http://peltiertech.com/Excel/ChartsHowTo/index.html
or just
http://petiertech.com

================================================== ==

Sileesh wrote in message
...
Hi

I am newbie. I have an excelsheet with 5 Columns A,B,C,D,E,F. Columns B,
C,E
are dropdownlists. Now my problem is how to generate a bar-graph on
Columns
A,B,C, E,F dynamically based on the data in the excel. The data in excel
might get added or removed.

How to do this ? Any sample code wld be great.

Pls help