Hi

what do you want the graph to look like?

Cheers
JulieD

"Sileesh" wrote in message
...
Hi

Here is how my Excel sheet look like. Equipment, Shift and Reason are
dropdownlist. Each time we enter data in row, we choose one of option from
Dropdownlist.

Date Equipment Shift HrsAvail Uptime Reason

11/01/04 EqipA Day 10 10 Rea1
11/02/04 EqipB Night 10 6 Rea2
11/03/04 EqipC Day 10 8 Rea2
11/04/04 EqipA Day 10 10 Rea3

So what i am asking now is, the data in the seet changes very often. So i
have to somehow be able to generate bar graph automatically. Can this be
done
thru a macro or VB script by selecting the x n yaxis dynamically from one
of
the heading above?

Also how can we read all the options from each dropdownlist in vbscript?

Pls help


"JulieD" wrote:

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