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
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 58 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives