Create a Column chart

A category chart is a vertical column or horizontal bar chart used to compare values used to compare values across categories or over time.

Step 1: Select “Charts” in the menu bar to view all the Chart visualisation options.

Step 2: Select “Category Chart” option.

Note: The default column chart will be placed on your Dashboard. Drag it to wherever you want by grabbing the header and you can resize it by dragging the bottom right corner.

Step 3: Click “Edit”   menu on the chart header to edit your chart’s data, appearance and social media settings.

Link data to your chart

Step 4: To link data to the chart, select the “Data” tab in the edit popup, select the data file from the left file tree.  The file will open in the right data selection area. For a time series chart, only data with a date-time column can be selected.

Step 5: Select your columns which you want to represent on the chart. Click on” Choose as x” the column you want to represent as a category on x-axis and Click on” Choose as y” the columns you want to represent as the values on y-axis.

Note: For “choose as x”, your file should have either a text based or date-time based column to use as category. You can check the datatype of column by clicking the column in “Data Wrangler”.

Note: If you want to select specific data to use as error values, you can select those columns from the tab area named “Error bars”.

Step 6: A preview of your chart will be generated (the box with the black border). You can resize the preview by pulling the bottom left corner.

Style column chart

Style each data series (lines and points on the chart) by altering the options in the ‘Data Series’ tab.

All Series options

“All Series” selection allows you to manage settings that apply across all series such as stacking and range.

  • Hover: to show the values if you hover over it.
  • Column style: The presentation of column, side by side or overlay or stack.
  1. side by side: It places each column next to other column.
  2. overlay: It places each column in the same place in X-axis. It is important that the larger value columns are behind the lower values (top of the legend list) otherwise the higher value columns will obstruct the lower value columns. For overlay, the Y axis applies to all columns.
  3. Stack:    (Standardise y: 0-1, 0%-100%, None): It places each column on top of each other. For stacked columns, the chart can be re scaled to show a 0-100% range rather than an absolute value.

Series style options

  • Name: name of the series (default name is the column header).
  • Type: The type of that particular series; line or column (switch to column to create combination line and column charts).
  • X-Axis: the x-axis in the chart, you can choose a secondary date-column if needed.
  • Y-axis: to manually reset the Y-axis of the chart.
  • Axis: by default, the series uses the left Y-axis, but you can switch to using a secondary Y-axis (right Y-axis) to allow you to show two different scales on the same chart.
  • Error-bars:
  1. Same +ve and -ve: same error in both directions.
    1. Error: set whether the error is represented as “Data” in a column, or defined below.
    2. Error Data: Select the error column if error is represented in the data file.
    3. Error Type: If error is not contained in a column in the data file, you can define the error as a percent of the underlying data, a fixed value, the standard error or the standard deviation of the underlying data column.
    4. Error Value: relates to the error type selected.
    5. Styles: Style the error bars.
  2. Difference +ve and -ve: different positive error and negative error.
    1. The same settings as same +ve and –ve can be applied to both the positive and negative error representation.
  3. Hide: default behaviour is to show no error bars.
  • Legend: It includes the series in the legend.

Global style options

Style the overall look of the chart by altering the options in the ‘Global Styles’ tab.

  • Title: title of the chart.
  • Title-font: the title which is font, size and colour.
  • Background: the background colour of the chart.
  • Font: the text in the chart, its size and colour.
  • Margin: the top, bottom, left and right margin.
  • Outline: the thickness and colour of the outline.
  • Padding: the padding around the chart.

Legend style options

  • Font: font of the legend.
  • Visible: if the legend needs to be visible or hidden.
  • Background: background colour of the legend.
  • Border: the border and its colour around the legend.
  • X-position: the position of the legend with respect to x-axis.
  • Y-Position: the position of the legend with respect to y-axis.

X-axis style options

  • Name: name of the axis.
  • Font: properties of the name of the axis.
  • Range: the upper and lower values on X Y axis.
  • Axis line: visibility of axis line (show or hide).
  • Grid line: visibility line of grid line (show or hide) and its width.
  • Zoom: to allow the user to zoom on the chart. Interactive allows simultaneous zooming on both X and Y Axis.
  • Zero line: include the zero line on the chart.

Y-axis style options

  • Name: name of the axis.
  • Font: properties of the name of the axis.
  • Mode: toggle the Y axis to linear or logarithmic (base 10) scale.
  • Range: set the maximum range of the Y axis.
  • Axis line: visibility of axis line (show or hide).
  • Grid line: visibility line of grid line (show or hide) and its width.
  • Zoom: to allow the user to zoom on the chart. Interactive allows simultaneous zooming on both X and Y Axis.
  • Zero line: include the zero line on the chart.

Edit the settings of your visualisation for sharing on social media

To edit the information that will accompany the chart when sharing on social media (Facebook, Twitter, etc.), select the ‘Social’ tab.

Share your visualisation

Share your visualisation or the entire dashboard using “Share” tab under “Dashboards”.