VBA question regarding changing the colour of stacked columns

[ToyBoi]

I hope everyone doesn't mind that I'm asking a question regarding vba in this forum, but Ozgrid is charging $1 for each topic!

In the above picture, I have a stacked bar graph. the first stack is light blue, the second is maroon, and the last is light yellow. How do I get vba to change those colours to what I want. I recorded macros for this but it doesn't work for stacked columns. The following is the code when I tried to record a macro.

With Selection.Interior
        .ColorIndex = 48
        .PatternColorIndex = 1
        .Pattern = 1
    End With
    ActiveChart.PlotArea.Select
    With Selection.Border
        .ColorIndex = 16
        .Weight = xlThin
        .LineStyle = xlContinuous
    End With
    With Selection.Interior
        .ColorIndex = 56
        .PatternColorIndex = 1
        .Pattern = xlSolid
    End With

It said that the system doesn't support this operation.

Edited August 28, 2008 by ToyBoi

[PsaltyDS]

I hope everyone doesn't mind that I'm asking a question regarding vba in this forum, but Ozgrid is charging $1 for each topic!

So, you thought you would run up the hosting bills for AutoIt instead?

Please don't use the AutoIt forums for off-topic questions. If you are a regular AutoIt user aside from this question, then you could probably get help in the Chat forum.

[zfisherdrums]

ToyBoi,

I have the answer to your question but I will not post it here. Please post your question in Chat and I will provide the answer.

Thanks,

Zach...