User Profile
Maggi685
Copper Contributor
Joined Oct 03, 2023
User Widgets
Recent Discussions
How to autmatically change the bar color for certain chart bar without manually change
I need some help, I have already tried to figure it out by myself for many days, but still, it does not work. I have the below table (Image 1), and I want to make the bar charts (like waterfall chart), but the chart only includes the items when their value is not "0". I built up the formula behind it, and it works all ok (see image 2). I also made the bar colors as specific colors as the items in the table. But when I gives some data for T8 for example, the chart will inlcude the addtional bar for T8, which is good. But the color also change corresponsdingly (Image 3). I would like to keep the T1~T10 in the green color, and 'Pay' bar in green-blue color, and 'Profit' with the dark blue one as the image 2 bar colors. I would like to bar colors change automatically without manual change. Really appreciate if anyone can help me to solve this challenge. Thank you. (Image 2) (Image 3)
