Just a guess, but maybe this is what you need: Your data is as follows
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
Select the Header row (i.e date, equip... etc), Click DATA FILTER
AUTO FILTER.
This will display dropdowns for the headers and now you can select an
given equip or day/night or reason, and filter the data.
Now select the date column, the HrsAvailable and Uptime columns. Draw
bar graph.
Now when you select a given equip, day/night, or reason, the graph wil
display only the filtered data
--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile:
http://www.excelforum.com/member.php...fo&userid=1047
View this thread:
http://www.excelforum.com/showthread.php?threadid=27759