Column charts allow you to plot a series of data into vertical columns, with optional labels for each column. Column charts also have an optional goal field which can be set to highlight values above a specific target.
To create a column chart using spreadsheets, follow these steps:
- Use the Widget Selector, located in the top right of the Spreadsheets widget set-up screen, to change the widget type to Column Chart.
- Click in the X-Axis field.
- Select the data from your spreadsheet for your X-Axis by either typing in a cell selection (e.g. A:A), clicking and dragging over your desired cells in the Spreadsheet Data area. As you do this, the cells will highlight and you’ll see a live preview of your Column Chart.
- Click in the Series field.
- Select the data from your spreadsheet for your first Series by either typing in a cell selection (e.g. B:B), or clicking and dragging over your desired cells in the Spreadsheet Data area.
Note: The Series fields will take numeric data, along with currency symbols and % signs.
Tip: Use the Use first selection cells as header toggle to replace the series name with the value of the first selected cell.
- Use the Goal toggle to activate the Goal field.
- To add a Goal, type in the goal number, or select a particular cell from the Spreadsheet Data area (e.g. D2). Grey shading will be added to columns that don't meet the goal to reflect this and any columns that meet the goal will turn green in color.
- Give your widget a Title.
- When you’re happy with your Column Chart, click Add to dashboard.
More ways to visualize your spreadsheets
Now that you’re familiar with how to create a column chart, read our dedicated guides to creating the different visualizations available.
- Line Chart
Plots multiple series of values and visualize these trends over a period.
- Bar Chart
Plots a series of data in a horizontal bar chart, with the option for individual labels for each column and a goal field, which can be set to highlight values above a specific target.
- Number Widget
Consists of a single number pulled from a specified cell. Enables you to visually compare two figures with 4 comparison visualizations:
Displays a primary metric with a sparkline (a small line chart) below it.
Displays a primary metric with a percentage change value below it that compares the primary metric with a secondary number.
Displays a primary metric with a value change below it that is a calculation of the difference between the primary metric and a secondary number.
Displays a primary metric with a goal change below it that is a calculation of the difference between the primary metric and a secondary number.
Consists of a ranked list of items, each with a label and an optional value.
A gauge visualization to quickly see a metric in comparison to defined minimum and maximum values.
Displays non-numerical data from a cell, or multiple cells, in a spreadsheet.