Highlight Bars with Above/Below Average Values in a Column Chart | Help and How-To

harikm007 · 2024-10-22T05:37:23.672000Z

In this guide, we’ll explore how to highlight bars with values above or below the average in a column chart using Sisense's built-in features. As you may have already seen, we can also highlight min and max values in a line chart using a script. Now, let’s dive into the steps for making your column charts even more informative!Step 1: Create Your Column ChartStart by creating a column chart. Add your desired Categories and a Measure; for example, you select "Age Range" as your category and SUM(Quantity) as your measure. Step 2: Access the Color SelectorNext, access the color selector in the Measure panel, which opens a popup window. In this popup, you’ll find three options: Single Color, Range, and Conditional. Click on the Conditional tab to proceed. Step 3: Configure Conditional ColorsIn the Conditional tab, you can set conditions and corresponding colors for your bars. Highlight Above Average Values:Remove all conditions that are loaded automatically except the first condition.Select ">" from the dropdown..Click on the Formula option and enter the formula to calculate the average avg([Age Range], sum([Quantity]))Choose a color for the above average values. Highlight Below Average Values:Add another condition for the lowest value.Select "<" from the dropdown and use the same average formulaavg([Age Range], sum([Quantity]))Select a distinct color for the lowest value. Step 4: Apply Your ChangesOnce you’ve configured the conditions, click OK to apply your changes. Your column chart will now display bars representing values above and below the average in different colors, allowing for quick identification of performance against the average. See below post to find more detailed steps: https://www.binextlevel.com/post/highlight-bars-with-above-below-average-values-in-a-column-chart-1 Also see how to highlight Min and Max bars in a column chart: https://www.binextlevel.com/post/how-to-highlight-max-and-min-bars-in-a-column-bar-charts -Harihttps://www.binextlevel.com/

MoreDiscussions

Highlight Bars with Above/Below Average Values in a Column Chart | Help and How-To | Sisense Community