Bar Chart Colors

[FreddyD112]

Hello there,

I have a quick question if anyone can help me.

Basically, I'm creating a bar graph and have a series that covers TEST1, TEST2 & TEST3.

I don't want the default color of the individual bar graphs and want to change the colors myself to the traffic light system e.g red, amber green.

I've managed to figure out how to change the color of the bar chart, but since I can only change the series and plot all the bars change to the single color I've identified below.

chart_data = CategoryChartData()  
chart_data.chart_style = [1]
chart_data.categories = ['Test1', 'Test2', 'Test2']
chart_data.add_series('Total', (1, 4, 7))



top = Inches(3)
left = Inches(1)
width = Inches(5.45) # from top of slides X inches inward
height =  Inches(3.89)


Graph = Slide_IRstat.shapes.add_chart(XL_CHART_TYPE.COLUMN_CLUSTERED, top, left, width, height, chart_data)

chart = Graph.chart
plot = chart.plots[0]
series = plot.series[0]
fill = series.format.fill
fill.solid()
fill.fore_color.rgb = RGBColor(255, 230, 210)

Has anyone got advise of how i can change the bars colors individually? Say for example

1 = red

4 = Amber

7 = Green.

[FreddyD112]

Solved

[Muntasir13]

@FreddyD112 May I know how did you solve this problem? I have ran into the same issue as well.