Bar chart formatting question

I am trying to format a column chart with overlapping columns
the goal is to 'fill' the budget box with income and expenses colouring/pattern.

the goal is to show Budget, income and expenses.
Budget is a hollow box with no fill (this bit works)

Am trying to set income and expenses as a pattern, with a fore-color and transparent background color.
I can not see how to set the pattern background colour as transparent or 'null'.

Questions:
1. can this be done?
2. if so, how?

thanks heaps

I've got a workaround using stacked pictures as the fill - but this is very fiddly to set up.
I'd still be interested to learn of a better way to set the backcolor or forecolor to null/transparent - and end up with a column optionally with green, red or red and green stripes.

Code:

---

   
    With Selection.Format.Fill
        .Visible = msoTrue
        .Patterned msoPatternWideUpwardDiagonal
        .ForeColor.RGB = RGB(255, 0, 0)
        .BackColor.RGB = RGB(0, 255, 0)
    End With

---

There is no option for transparency with pattern fills.

Quote:

---

Originally Posted by Aflatoon

There is no option for transparency with pattern fills.

---

oh diddley squat.
Thanks for confirming though