A column chart displays the values of one or more measures by period or category. The height of a column reflects the measure value: the higher the column, the larger the value.
This chart type compares different periods directly with an emphasis on a measure's individual value rather than its general trend:
Visualization supports two column chart sub-types:
A grouped column chart allows you to compare two or more measures. The column height represents the measure value.
For example, you can use this chart type to compare the numbers of hotel bookings in different regions.
A stacked column chart shows the ratio of internal segments by period. Segments stack one above the other: the base of each following segment is the top boundary of the previous one.
Please note that the sum of all segments is equal to the total length of a column.
For example, the hotel booking ratio for two boroughs in the same region.
Open the All workbooks overview page and select your workbook.
Open the dashboard to which you want to add a chart.
In the upper-right corner, click Edit.
Click Add → Chart (Wizard). You'll see the chart creation wizard.
On the top left, select the Dataset you want to visualize.
Click the chart type field on the right of the dataset section and select Column chart from the drop-down menu.
Drag and drop Measures and Dimensions to the appropriate sections of the chart (see the Data fields tab).
Your chart creation wizard should look similar to the following:
To create column chart sub-types:
Add the dimension(s) you want to add as additional columns to the X axis field.
Add the same dimension(s) to the Colors field to differentiate them buy color.
- Add the dimension(s) you want to stack to the Colors field.
Click Save in the upper-right corner of the page.
Name your chart and click Done.
Choose the appropriate location for your chart by dragging it around the dashboard and resize it by dragging the lower-right corner of its frame.
Click Save in the upper-right corner of the page.
|Y||Measure. Multiple-field slot.
If you add more than one field to this slot, the
You can add a
You can delete the
|Sorting||Measure. Measures from the x-axis. Affects the sorting of the x-axis.|
|Signatures||Dimension or Measure. Shows dimension values on the chart. You can add a
|Split||Measure as a category. Separates a single chart into multiple by category.|
|Chart filters||Dimension or Measure. Used to filter values. You can add a
To open chart settings, click to the right of the chart type above the wizard slot fields. You'll see a dialog window with the following controls:
||Displays the specified text in the centered line above the chart.|
||Displays the field name associated with color line below the chart.|
|Sum in tooltips||
||Displays the sum of the values of all the lines on data point hover.|
||Allows the labels with a large amount of text to overlap.
Use with caution - this may negatively affect the labels readability.
After managing the controls, click Apply to see the results on the chart preview.
To open slot settings, click in a row with the slot name.
X and Y axes:
|Axis title||Sets an axis label.||Auto: Uses a field name. If the section contains several fields, Visualization uses the name of the field added to the list first.
Manual: Allows you to enter an axis title manually.
|Axis type||Sets the axis type. The setting is available for fields in the axis section that have the Fractional number type.||Linear: Sets a linear axis type.
Logarithmic: Sets a logarithmic axis type, preferable for charts with a wide range of values. A logarithmic axis allows you to display a fast-growing graph in a convenient form for analysis, reducing values by order of magnitude.
|Grid||Displays a grid on the chart.||
|Grid step||Sets the grid spacing in pixels.||Auto: Sets the grid size automatically.
Manual: Allows you to set the grid size in pixels.
|Labels||Displays data field labels on the chart.||
|Labels view||Sets the appearance of the label display. The setting is available if the Labels setting is set to
||Auto: Positions label values automatically.
Horizontal: Positions label values horizontally.
Vertical: Positions label values vertically.
Angle: Displays label values at a 45-degree angle.
|Empty values (null)||Specifies how to process empty values.
Not supported by Scatter chart.
|Ignore: Doesn't display empty values in a chart.
Connect: Joins values of fields that have empty values between them.
Display as 0: Displays empty values in charts as zero (0) field values.
|Scaling||Sets the scale of chart axes.||Auto: Sets the scale automatically. You can specify how Visualization sets the scale: from the minimum to the maximum field values (Autoscale from min to max) or from 0 to the maximum field value (Autoscale from 0 to max).
Manually: Allows you to set the axis scale manually. You can set the maximum and minimum values along the axis. Visualization trims the chart lines by this value.
On the left, you can select a line from a data source in the Colors slot of your chart.
On the right, you can select a color scheme and a color for the line. Select
AUTO to let Visualization do the coloring for you.
If each column represents a category rather than a time value, sort the columns in ascending or descending order to make your chart look better and more informative.
If you make a stacked column chart, apply this principle to how you sort the values.
When visualizing multiple measures, consider which of them needs the most attention. For better readability, put the most important measure at the bottom of the fields list and the measure against which you want to compare it - at the top:
We recommend displaying no more than three to five measures in a chart.
To display the values for each data point, drag Measure values to the Signatures section.