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?


Tags:

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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
    SoS | Dan Palenchar ✭✭✭✭✭✭
    edited 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:

    1. Create separate columns for positive/negative values,
    2. Use formulas to pull in values to the appropriate column,
    3. 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!