Conditional Formatting on Bar Charts

MRedivo

Is there a way to add a conditional formation on bar charts? I need to show past months in one color and future months in another color. I have the logic created and it's working fine on a grid but cannot make it work on a bar chart. Thanks

JeffreyG

Hi @MRedivo - There currently is no direct conditional formatting type settings you can apply to a bar chart. However, you can still achieve the desired effect through the following:

1. Create an "Actuals" line item for past months and only populate values during those months (future months should show 0)
2. Create a "Forecast" line item for future months and only populate values during those months (past months should show 0)

You can then create a bar chart using both those two line items, and color each differently as needed. Since they each drop to zero when they aren't applicable, you will only see them during those respective periods on the chart. You could then apply the stacked bar chart style to this, so that they both appear centered for each time period (if needed).