RAG Graph

[dvent]

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

[sweep]

Hi,

You can find what you need here http://peltiertech.com/Excel/Charts/...nalChart1.html