An area chart is a type of data visualization that shows different categories or variables as layers on a single chart. It allows easy comparison of components and their changes over time or in relation to other variables.
Chart properties
Stacking - in a stacked chart, values are displayed one above the other rather than overlapping.
Stacked 100% - the chart shows the values as a percentage of each value in the total, which helps you see how each value affects the entire category in relation to its proportion.
Stacked 100% - the chart shows the values as a percentage of each value in the total, which helps you see how each value affects the entire category in relation to its proportion.
Inverted - in a rotated graph, the X axis is vertical and the Y axis is horizontal
Serie - a stratified chart can contain several series
Name - the name displayed in the legend and in the labels that appear 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 fetch the correct records. If the data is typed directly into the field or given as a cell address, you can leave the field empty.
X - if the data is retrieved using the lookup function, indicate the column from the associated record. Otherwise, you can specify a range of cells or an array of values. If X values are not specified, points on the X axis will be assigned to consecutive natural numbers or categories.
Y - if the data is fetched using the lookup function, indicate the column from the associated record. Otherwise, you can specify a range of cells or an array of values.
Example 1.
We have a layer chart that compares revenues for the years 2023 and 2024. The data for the chart is taken using the lookup function.
The X axis represents the months of the year, stored as text (e.g., “January,” “February,” etc.). If the values are text, set the X-axis type to categories. By default, the values on the X-axis are sorted in the order in which they are retrieved from the table, so it's a good idea to specify the correct order of months manually to avoid a wrong layout.
The Y axis shows the revenue values for each month. Since the chart is designed to compare results from different years, data for 2023 and 2024 are displayed as separate series.
Chart properties
0 Comments