I am trying to create a bar graph in excel that has a gradient color
scheme that goes from yellow to red as the predefined severity of a
risk increases from low to high. The count of each value that is being
risk ranked should also be displayed on the graph.

Count Risk (1 = L, 6 = H)
Type A 2 1
Type B 2 2
Type C 4 3
Type D 5 4
Type E 1 5
Type F 7 6

Bsically, I'm looking for one horizontal bar graph to look as follows:
L M H
2 2 4 5 1 7

Any suggestions?