A line chart is one of the simplest and most commonly used tools for visualizing data. It consists of points connected by lines, which makes it easy to see increases and decreases in values.
Line chart - designer
Properties
Chart subtype - specifies a particular type of chart. In the case of a line chart, two variants are available:
Line - a classic line chart with straight segments connecting data points
Spline - a chart with rounded edges, creating a smoother line
Series - a line chart can contain several series
Name - this is the name of the series that will be displayed in the legend and in the label when you hover over a point on the chart.
Data - if the data comes from an external table or list, use a lookup formula to retrieve the relevant records. If the data is typed directly into the field or given as a cell address, you can leave the field blank.
X - if the data is retrieved using the lookup function, indicate the column from the related record. Otherwise, you can specify a range of cells or an array of values. If X values are not specified, the points on the X axis will be assigned to consecutive natural numbers or categories.
Y - if the data is retrieved using the lookup function, specify a column from the associated record. Otherwise, you can specify a range of cells or an array of values.
Data bullet - determines the shape of the points on the chart.
Data labels - labels that help the user read the values on the chart:
- Tooltip - When you hover over a point on the axis, its value will be displayed
- Fixed - values are displayed directly on the chart
- None - labels will not be displayed
Example 1
The chart shows a comparison of revenues for the years 2023 and 2024. The data is taken using the function - lookup.
The X-axis represents months, stored as text. To improve their display, change the type of the X axis to categories. By default, months can be sorted by order in the table, so it is worthwhile to enter the correct order in the categories.
The Y axis represents revenue values
Chart properties
Line chart showing revenue in 2023-2024
Example 2
The chart shows a comparison of revenues for 2023 and 2024. The data is taken from the table section.
The X-axis represents months as text, so change its type to category. The data will be displayed in the order in which they appear in the section - table. To maintain the correct order, enter the correct sequence of data in the “Categories” field.
The Y-axis represents the revenue values
Chart properties
Line chart showing revenue in 2023-2024
0 Comments