Line chart: Difference between revisions

From Planfix
Jump to: navigation, search
Line 23: Line 23:
In "Data to display", set the following:
In "Data to display", set the following:
**Columns on which the chart will be based: "Overdue tasks", "Completed tasks".
**Columns on which the chart will be based: "Overdue tasks", "Completed tasks".
**Grouping:By the "Assignee" column.
**Grouping: By the "Assignee" column.
**Sort:by the "Completed tasks" column, by month, ascending.
**Sort: by the "Completed tasks" column, by month, ascending.
https://s.pfx.so/pf/iC/Z8rSF4.jpg
https://s.pfx.so/pf/iC/Z8rSF4.jpg
*In the "View" section, you configure how the chart is displayed:
*In the "View" section, you configure how the chart is displayed:

Revision as of 08:41, 18 June 2025

A Line Chart is one of the chart types available in Planfix reports. It displays data as points connected by lines and is therefore ideal for visualizing trends over time or relationships between values. This chart is suitable for tracking changes such as task completion, sales growth or project progress.

For example, you can display overdue and completed tasks by employee over the past month like this:

pafV4I.jpg

The line chart is created from report data and consists of two axes:

  • Horizontal axis (X) — represents categories (e.g., days of the week, project names).
  • Vertical axis (Y) — represents numerical values (e.g. number of tasks completed, hours worked, sales amounts).

To ensure that relevant data is displayed, use grouping and sorting.

Setup

  • In the "Report view", add the columns that will form the line chart.
  • Go to the "Charts and graphs" section and add a new "Line" type chart:

rTfZbG.jpg In "Data to display", set the following:

    • Columns on which the chart will be based: "Overdue tasks", "Completed tasks".
    • Grouping: By the "Assignee" column.
    • Sort: by the "Completed tasks" column, by month, ascending.

Z8rSF4.jpg

  • In the "View" section, you configure how the chart is displayed:
    • "Chart height" — defines the height of the chart in pixels.
    • "Legend location" — controls how the axis labels are displayed. Tip: Use "Vertical" for longer labels to save space, "Horizontal" is best for shorter labels.
    • "Colors" — helps to differentiate between data groups using different colors.