On Wed, 25 Apr 2007, in microsoft.public.excel.charting,
Bill Gates said:
I have created a gantt chart using a stacked bar chart and hiding the first
series. The tasks also have a different priority. Is htere a way I can use VB
to change the colour of each task bar depending on the priority. I have 3
prioritys, either high medium or low.

Why would you resort to VBA, instead of simply having three data
columns?

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.