Create a Time series chart

A time series chart is a line chart used to show a trend over time. The X-axis (horizontal axis) represents time and the Y-axis (vertical axis) represents values. Time series charts can only be created with data that has a date-time column (each row if a different observation through time).

Important

To create a time series chart, you must first create a dashboard on which to add it.

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

Step 2: Select “Time series Chart” option.

Note: The default time series 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 the data columns that you want to display on the chart. Select ” Choose as y” whichever columns you want to represent in your chart.

Note: For “choose as x”, your file should have date-time column associated with it. 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 time series 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: It will show the values when you hover over the chart.
  • Line style:  overlay- the default view is that time series are overlayed and all series relate to the same Y axis value. If the line series are stacked, then, the series Y value is added to the value of the preceding line series. For stacked line series (often called and area chart) the Y axis can be re scaled to 0-100% to show the relative size of each time step.

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: 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.
  • Line: Style the line for the selected series.
  • Marker:Mark the values on the line of selected layer with the styles, border (thickness of points) and number (amount of marking points).

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 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 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”.