Bar chart formatting

[mechpm]

I found on this web site (tip of the week) a Bar chart. It's something I have been trying to do for sometime now.

Of course my brain Say's you must modify this thing. So this is my project for the week.
(O k one of them anyway)

I have added some simple man hr calculations, estimated hrs and actual hrs type stuff.
What I need now is to change the colors based on an activity scheduled.

Example
activity start finish
controls 5-20 5-30
chiller 5-25 6-30

Controls would advance bar in red and install chiller would advance in green ect.

If I could do this for the three allowed conditions it would work. However, more options would of course be better.

I have played with some if then stuff to no avail.

I hope that the above will aid you in understanding my goals. And help you help me.
Should you need any further info? let me know.

Thx

R W


[ This Message was edited by: mechpm on 2002-05-19 10:39 ]

[ This Message was edited by: mechpm on 2002-05-19 10:41 ]

[ This Message was edited by: mechpm on 2002-05-19 10:42 ]

[Anne Troy]

Sounds like you need a Gantt chart, not a bar chart. Perhaps something like this:

http://www.mrexcel.com/tip058.shtml

[mechpm]

On 2002-05-19 12:21, Dreamboat wrote:
Sounds like you need a Gantt chart, not a bar chart. Perhaps something like this:

http://www.mrexcel.com/tip058.shtml

[mechpm]

On 2002-05-19 12:21, Dreamboat wrote:
Sounds like you need a Gantt chart, not a bar chart. Perhaps something like this:

http://www.mrexcel.com/tip058.shtml

That would be it.

now how would i cange the colors based on the activity (or under the header, Type in the linked exapmle)

[ This Message was edited by: mechpm on 2002-05-19 12:58 ]