Using gradient aspect to the chart

[Cooperdam]

I have a chart that shows the budget and expense amounts. I have the color yellow for budget and red or green for expense, depending on if it is over the budget amount or not, (green is good,etc).

Is there a way to have the color softer and more gradient from green to yellow to red as the budget is approached and gone over?

 

[RiverGuy]

So at the moment, do you have a yellow bar (or line) with a red or green bar next to it, for each item in the series? If this is the case, then are you saying you want the red or green bar to be a mixture between red and green, or that you want a gradient so that it begins at green and ends in red?