Bar chart formatting question

[werafa]

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

[werafa]

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.



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