Hi All,
I've not really done much on graphs in excel and am attemping to create a Red/Amber/Green chart.
I have some data listing a project and the number of weeks it has been running.
I have a few lookup cells also with the max number for Red Amber & Green.
E.g.
Project A running for 20 weeks
Project B running for 35 weeks
Project C running for 10 weeks
Project D running for 45 weeks
Green is up to 25 weeks
Amber is 25 to 40 weeks
Red is +40 weeks
I would like to show each project on a graph with a column that starts green, goes amber where applicable and obviously goes red if the project has been running for 40+ weeks.
Thanks
dvent
Bookmarks