Summary: Column Charts are very widely used to visualize data with one or two dimensions and one metric.
Columns charts are very simple yet popular charts. Your data needs to have one dimension and one metric to
be represented in a column chart.
Column charts can also have multiple metrics, which will show each metric with a column having different color.
Column charts can also have 2 dimensions, in this case the first dimension will be on the X axis and the second dimension would be represented by multiple columns with different colors
Chart Options
| Option | Explanation |
|---|---|
| X Axis | The Dimension used to populate the X axis values. |
| Series | If there is one metric only, this will show the metric used. If there is a second dimension, this will show the values of the segments of the second dimension (each will be drawn in a different color). |
| Show Trend Line | Select the series that you would like to draw a linear regression line. This is useful to see the overall trend of your data, whether growing or declining. |
| Switch X-Axis/ Series | Provides an alternative view of the chart by switching between fields of the Xaxis and the series. For example, if you have two dimensions in your search or question, this will switch between the dimension used to populate the X axis and the one used to populate the segments draw with different colors. |
| Show Data Labels | Will show numeric data labels for each data point in your chart. |
| Numbers Format | Change the format of the numbers used in the Axes, data labels and on-hover data call-outs of the chart. |
| Legend Location | Select the location for the legend that shows the color coding of the colored stacked segments. |
| Sort Y-Axis | Select the value by which you would like to sort the Y axis. This can be the Y axis dimension or the value of any of the segments from the second dimension. |
| Limit X axis Values | This limits the number of columns that are drawn across the x Axis. By default, there is no limit. |
| Show Other category for X axis | This aggregates all values that fall beyond the limited number of columns into one category called “Other”. This is useful for charts where the higher values are consolidated within the first few segments, as it will aggregate all other segments into other and show as a separate point in the graph. This option is only available if there is a limit set to the number of columns. |
| Rows Per Page | Allows to separate the chart into pages. You can go to the next or previous page by the links on the top right corner of the chart. |