Bar Charts (Workbooks)
Summary of Content
Plot a Bar Chart
Visualized data will not display on the page canvas until all required plot fields are defined.
Add columns to open fields using either the field's + menu or dragging and dropping the column.
- X-AXIS (1 column)
- Y-AXIS (1+ columns)
Columns added to the Y-AXIS field are aggregated by default. Aggregation type (e.g. Sum vs Count) is dependent on the original column’s value type (e.g. text, number, date, etc).
For example, a numeric column such as 'Sales Amount' will create a new calculated column, 'Sum of Sales Amount' (e.g. Sum([Sales Amount])).
- COLOR (1)
- TOOLTIP (1+)
- TRELLIS (1 TRELLIS ROW and/or 1 TRELLIS COLUMN)
Bar Orientation (Horizontal vs Vertical)
Bar charts can be displayed both vertically and horizontally.
To select your chart’s orientation, select either the ‘display vertical’ or ‘display horizontal’ icon buttons in the chart’s editor panel view.
Stacked Bar Variations
Bar charts support three stack variations: no stacking, stacked, and stacked 100%.
To create a stacked bar chart, first add a column to the COLOR field. Then optionally select one of the three stack options from the top of the chart’s editor panel view, if you are not satisfied with the default stack arrangement.
To begin editing a visualization's format options, select the visualization to open its editor panel view. Then click the paint brush icon at the top of the editor panel.
The following Format options are available for bar charts:
- Data Labels
- Reference Lines
Show Data Labels
- Open the chart’s editor panel view, and click the paintbrush icon to open the format settings.
- Click DATA LABELS.
- Click Show data labels.
- [optional] Use the dropdown menus to customize the labels’ color, orientation, position or font.
Add a New Rule
- Select the chart to open its editor panel view.
- Under MARKS > COLOR, click + Add rule.
- A new undefined rule will appear. Click to edit.
- In the popup:
- Select a column to apply the rule to (Apply to).
- Define your Formatting rule.
- Click the paint bucket icon to select a color.
If multiple rules are applied to a single column, you may need to order your rules by precedence. Rules higher in the list take precedence over their lower peers.
Drag and drop rules to reorder them.
In the example below, Rule #1 colors all bars with a value > 1,000,000 green. Rule #2 colors all bars with a value > 0 purple. Rule #1 applies to only a select set of bars in the visualization. However, Rule #2 applies to all bars.
Scenario #1: If Rule #1 is listed first, it will take precedence over Rule #2. All bars that fit the criteria of Rule #1 will be colored green. Rule #2 cannot override this higher rule and will only checked against and applied to the remaining bars.
Scenario #2: If Rule #2 is listed first, it will take precedence over Rule #1. In this case, Rule #2 happens to apply to every bar. All bars will be colored purple, including bars that would have otherwise matched Rule #1.