Bar Chart Colors based on Value
I have a bar chart (below) where i have positive and negative numbers. How can i have the bar representing the negative number to be red, while the others blue?
Answers
-
Unfortunately it is not possible to dynamically change the bar colors based on the data set. Please feel free to Submit a Product Enhancement Request when you have a moment.
-
Hello @Umesh Shah
I made a video showing you how to do this, check it out here. Note that I ended up making a report to feed the chart as opposed to the Source sheet to prevent series loss (so I recommend you do this as well).
To make this work, you need to:
- Create separate columns for positive/negative values,
- Use formulas to pull in values to the appropriate column,
- Reference these columns in your chart and apply the formatting you would like to each column.
You can view the dashboard and interact with the chart here.
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 360 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives