A column chart is a graphical form of representing data by means of rectangular bars of height proportional to numerical values. It is used to compare different categories or observe changes over time. It can be vertical (bar) or horizontal, depending on the axis layout.
Column chart - designer
Chart properties
Stacked- will allow you to see how revenues from each customer changed and how much the total amount was in a given year.
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.
Separate colors in series - allows you to define a different color for each point in the series
Bar overlapping - determines the placement relative to each other of bars from different series that have compatible values on the X axis.
- None
- Partical
- Full
Series
Series - a column chart can contain several series
Name - this is the name of the series, which will be displayed in the legend and in the label when you hover over a bar on the chart.
Data - if the data comes from an external table or list, use a lookup formula to get the correct 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, columns will be assigned to consecutive natural numbers or categories.
Y - if the data is retrieved using the lookup function, indicate a column from the associated record. Otherwise, you can specify a range of cells or an array of values.
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
Second Y-axis - allows you to assign values from this series to the second Y-axis displayed on the right side of the chart.
Example 1.
The graph shows the company's financial data, which is retrieved using the lookup function.
- The X axis represents the year stored as text. Since the values are text, you should set the X axis type to categories. By default, the data is sorted by order in the table, so it is a good idea to enter the correct order in the categories.
- The Y axis shows financial values.
Data series and their chart types:
Revenue - indicates the total income generated by the company.
Costs - presents the expenses incurred.
Profit - shows the difference between revenue and expenses
Properties
Column chart
0 Comments