Bar Chart Colors based on Value

Umesh Shah · 08/31/21

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?

Paul Newcome · 09/01/21

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.

SoS | Dan Palenchar · 09/03/21

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.

Bar Chart Colors based on Value

Answers

👨🏼💻 Dan Palenchar | School of Sheets Solutions Consulting | Smartsheet Aligned Gold Partner

Categories