Graduated colouring on bar graph

[Dropdeadhomer]

I am trying to create a graph where the vertical axis is a list of projects (project a, project b etc) and the horizontal axis is a series of months (jan-dec).
I would then like to have a bar for each of the projects that runs horizontally for each project depending on the months that work will be happening (eg project A has a bar from jan to mar, project B jan-sept etc)
What I would then like to be able to do is to cross ref each month against a separate “impact” score and colour code the bat accordingly.
So, for example Project A is building from Jan to Oct, so it has a horizontal bar from Jan to Oct. The impact of this is (on a 1-8 score with one being low/green and 8 being high:red) a 2 in jan, a 4 in feb, a 7 in mar and apr, a 5 in may, June,July an 8 in August, a 4 in sept and a 2 in Oct.
is there anyway that the horizontal bar from jan thru to Oct can be colour coded linked to the impact score?
If so, it would have to be code-free as this would be used for a work slide and coding not allowed.

 

[JGordon11]

Not sure how to do that in a chart. Can do something similar with conditional formatting:

Book2 (version 2).xlsb.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Start	End	Project	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2	January	October	Project1	2	4	7	7	5	5	5	8	4	2
3	February	August	Project2		2	4	3	5	6	3	3
4	March	July	Project3			1	2	6	2	4
5	April	November	Project4				8	1	5	6	5	3	7	3
6	May	December	Project5					7	2	1	4	8	8	8	2
7	August	October	Project6								3	4	8
8	July	December	Project7							1	1	3	2	8	6
9	August	November	Project8								7	4	1	4
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D2:O9	Other Type	Color scale		NO