format waterfall chart vba

[Av8tordude]

I used the macro recorder to create a waterfall chart, however, I can't seem to record change the Orange bars to Red and the Blue bars to Green. Also I like to remove the values from the chart. I The marco recorder doesn't record changing the colors. Can someone help me with a vba code to do this task. Thank you kindly.

    ActiveSheet.Shapes.AddChart2(395, xlWaterfall).Select
    ActiveSheet.ChartObjects("Chart 10").Activate
    ActiveChart.Axes(xlValue).DisplayUnit = xlThousands
    ActiveChart.Axes(xlValue).HasDisplayUnitLabel = True

 

[mole999]

peltier charts web search