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.
👨🏼💻 Dan Palenchar | School of Sheets Solutions Consulting | Smartsheet Aligned Gold Partner
If this helped, help me & the SSC by accepting and reacting w/ 💡insightful, ⬆️ Vote Up, and/or ❤️Awesome!
- 🆘 Smartsheet Consulting Inquiries: schoolofsheets.com/workwithus
- ▶️ Smartsheet Tutorial Videos: schoolofsheets.com/youtube
PS - If you have a follow up response tag me @SoS | Dan Palenchar so I get notified of your reply!