How can I change the color of a bar chart in Splunk Studio 9.0.3?

[AlejandroRmM]

I want to change the color of the bars to green for approved and red for declined. I have tried using seriesColorsByField, but it does not change the color

[ITWhisperer]

"Approved", "Declined" etc are not series, they are values on the x-axis. You need to refactor your search to create series. If you need help doing that, please share your data source code.

[AlejandroRmM]

I made changes, but I can't manage to change the color.

index="db_pci_mssqlatom" sourcetype=*
| dedup 1 _raw
| top trans_status showperc=0
| transpose 0 header_field=trans_status
| search column="count"