Hi

if you're just asking how you can graph the information from say A1:F20 (for
example) then the easiest way is to select the range (if you really want to
miss out column D then select from A1:C20, hold down the control key and
then select from E1:F20 (you need to do it in this order)) then press the
F11 key ... now choose Chart / Chart type from the menu and choose the bar
chart. This will change when the information in these columns changes.

if you're asking anything else, please post back with a sample of your data
(please don't attach a workbook) and a more detailed description of what you
want to see.

Cheers
JulieD

"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