Range charts

Discover how Range Charts help visualize data variability and compare minimum and maximum values across categories.

Dumbbell column

Dumbbell column

• Axis parameter - Month

• Values parameter - Actuals, Plan (Created a new measure = Plan/2 for demo purposes)

• Chart type - Dumbbell column

• Description - A dumbbell chart (also known as a dumbbell plot) is useful for comparing two values for each category, typically highlighting the difference between them.

Dumbbell dimension and measure configuration

1. Canvas settings for dumbbell charts

1.1. Marker style

Set the marker shape, style, color and size.

Marker style

1.2. Rounded edge

Customize the appearance of the dumbbell.

Rounded edge

Dot Plot column

Dot Plot Column

• Axis parameter - Month

• Values parameter - Actuals, Plan (Created a new measure = Plan/2 for demo purposes)

• Chart type - Dot Plot column

• Description - A dot plot column (often referred to simply as a dot plot) contains individual data points represented by dots along a single axis. Multiple dots can stack up in the same position, making it easy to see the frequency or concentration of certain values.

Measure/dimension config for dot plot

Arrow Plot

Arrow Plot

• Axis parameter - Country

• Values parameter - Sales, COGS

• Chart type - Arrow Plot column

• Description - Arrow plots are ideal to depict the changes or movement between two points. They are easy to interpret and can be used to show revenue growth or price changes.

Data management for Arrow Plots

1. Canvas settings for arrow charts

1.1. Line style

Set the thickness of the line and choose between solid, dashed, and dotted styles.

Line styles for arrow charts

1.2. Marker style

You can opt for circular markers instead of the default arrow. You can also customize the size of the markers.

Arrow plot marker customizations

2. Legend settings for arrow charts

2.1. Show legend

The legend for arrow charts can capture increases/decreases in trends, providing clearer visual cues for data movement.

Legends for arrow charts

Range bar

Range bar

• Axis parameter - Country

• Values parameter - Sales, COGS

• Chart type - Range bar

• Description - Range bars are ideal to depict the variance between two points. They are easy to interpret and can be used to show revenue growth or price changes.

Pivot data for range bar

1. Canvas settings for range bars

1.1. Variance pattern

Select solid, outline, or hatched fill patterns to render variances.

Fill pattern

1.2. Rounded edge

Enable to toggle to soften the edges of the bars.

Rounded edge for range bars

1.3. Variance

Assign specific colors to depict a positive ot negative change in values.

Custom variance colors

• Invert color

Enable this toggle to interchange what variance colors stand for - red will represent positive, and green will represent negative.

Invert color