When to use the Column Chart widget
A column chart is one of the widget types that MSPbots users can utilize to highlight key data and identify actionable items for members, managers, and owners of MSPs. This widget type is helpful when comparing data presented in columns, bars, or stacking columns. Use this article to create a column chart widget.
Prerequisites
The procedure below requires admin access. Before starting, ensure you are logged in to MSPbots as an administrator.
How to create a column widget
- On the MSPbots menu, navigate to Widgets.
- On the Widgets tab, click New Widget.
- Browse the widget types on the New Widget window and select Column Chart.
- When the Widget Builder window opens, provide the following, then click the Apply button.
- Name - Give the widget a name.
- Description - Provide a short description.
- More Info
- Role - Select User or Admin
-
Tag
If you want to create or edit a Column Chart widget using the New Widget Builder mode, refer to How to Create a Column Chart Widget Using the New Widget Builder.
- Click
to go to Dataset and click the + button.
- Click New Layer on the Add New Layer window that appears.
- Do the following on the Dataset window:
- Select a Dataset to use and provide a name for this.
- Add columns by selecting an option from the Column Name dropdown list and assigning an Alias and Business Type for each.
- Click the + icon to add more rows.
- Add filters, measures, and dimensions.
- Choose a value for Order By and input for Row Limit, if necessary.
-
Click the Save button.
- Click Apply. This will show a default preview of the column chart that you created.
- Next, go to Config and provide data for the following fields:
Field Name Description Bar Chart Title Provide a title for the data being presented. Dimension Select the data for the x-axis (horizontal) of the bar chart. Multiple Measure If this is not selected, the y-axis will have one measure. If selected, multiple measures will appear on the y-axis, such as the left y-axis and the right y-axis. Measure Select the data for the y-axis (vertical) of the bar chart. Measure Color Select the color for the y-axis of the bar chart. Show Column Limit Set the number of columns to display on the Column Chart. For example, setting it to 3 will display 3 columns. Trend Line Select the preferred trendline from the dropdown list, if necessary. Label Font Size Set the font size for the label. X-Axis Font Size Set the font size for the x-axis. Set Goal Provide the preferred set goal, if necessary. Goal Color Select a color for the set goal. Measure-Line Select the preferred measure-line from the dropdown list, if necessary. Dimension Group Select the preferred dimension group from the dropdown list, if necessary. Type Select the Stacking Column,Column, or Bar from the dropdown list, if necessary.
- stacked Statistics - Enable this switch to display the column chart using stacked statistics.
- stacked Statistics Sort - Select descending or ascending to sort the stacked statistics.
Dimension Name Provide a name for the x-axis of the bar chart. Measure Name Provide a name for the y-axis of the bar chart.
- Y-Axis Percentage - Selecting this option will display the percentage on the y-axis.
- Right Y-Axis Coordinate - If selected, it will display the coordinates on the right x-axis.
- Use Right Y-Axis Measure - Select the measure for the right y-axis.
- Right Y-Axis Label Name - Enter the label name for the right y-axis.
- Right Y-Axis Percentage - Select to display the percentage on the right y-axis.
X-Axis Name Location Select Left, Center or Right as the location for the Dimension Name from the dropdown list, if necessary. X-Axis Name Gap Provide the preferred number of gaps for Dimension Name, if necessary. X-Axis Name Rotate Provide the preferred orientation for Dimension Name, if necessary. Y-Axis Name Location Select Bottom, Middle or Top as the location for the Measure Name from the dropdown list, if necessary. Y-Axis Name Gap Provide the preferred number of gaps for Measure Name, if necessary. Y-Axis Name Rotate Provide the preferred orientation for Measure Name, if necessary. Show Label The default is to show the labels. Remove the selection for the Show Label checkbox if you prefer not to show these. Split Line Show Select the checkbox for Split Line Show if you wish to show the split lines. (Optional)Overlapping Columns/Overlapping Bars Turn on this switch to make multiple columns/bars at the same X/Y-coordinate overlap with each other. This switch still shows the column chart widget with only 1 dimension and 1 measure, but will not take effect if turned on.
- When the option Type is selected as Column, the switch is named Overlapping Columns.
- When the option Type is selected as Bar, the switch is named Overlapping Bars.
- When the option Type is selected as Stacking Column, this switch is not displayed.
The overlapping column chart widget highlights overall trends, prominent outlier data, saves chart space, making it easier to display a large amount of data in a limited space, thus improving data visualization effectiveness.
Label Format You can configure the Label Format with the following tokens:
- {x_val}: The value of the x-axis
- {x_val2}: The dimension value of the legend
- {y_val}: The total value of the y-axis in the bar chart
- {y_val2}: If a stacked bar chart is selected, this is the value of each part of the y-axis.
- {measure_name}: The name of the y-axis
Chart Margin (Grid Setting) Turn on the switch, then you can customize and adjust the widget display size by entering pixel margins from the top, left, right, and bottom.
- Click Apply to save the settings.
- Go to Conditional Formatting. If you want the text color to change when the fields and measures meet specific conditions, set a conditional formatting rule for your column chart. Once a rule is set, click Apply on the Add a rule window.
- Lastly, click Apply on the Widget Builder window.