Column Chart

1) Column Chart is an effective visualization tool designed to display data variations over time or among different categories. It represents data through vertical bars, each bar height corresponding to its data value, making it straightforward to compare different data points visually. 

2) Column charts are particularly beneficial in identifying trends, comparing discrete data, and presenting data where the sequence of categories is important. Their clarity and simplicity make them a popular choice in business and finance for reporting and decision-making processes.

3) Application Scenario：Column charts are adept at illustrating how individual data points fluctuate over time and facilitate comparisons. For instance, they can showcase variations in traffic flow at a particular intersection during different periods, depict monthly sales volumes, or illustrate a company’s annual profits. This type of chart is highly effective for visualizing and comparing distinct, time-based data sets, offering clear insights into trends and differences.

4) Basic Requirement

5) Chart Feature

Advantage: Column charts can clearly display the quantities to help you compare the differences in the data.

Disadvantage: Column charts are unsuitable for large datasets.

Data Preparation

1. Log in to the system as the admin, click My Analysis, select a folder, and click New Subject.

2. Choose Current Project > Public Data, search for Sales Table, and click OK.

Component Creation

1. Click Component in the lower left corner.

2. Click the Custom Chart icon in Chart Type, and select Column Chart from the drop-down list in Graphic Property. Drag the City field into Horizontal Axis and the Sales field into Vertical Axis.

Chart Beautifying

Setting the Color

Click the Color column and set the color of the column chart, as shown in the following figure.

Note:

Columns can be displayed in different colors based on different cities after you drag the City field into the Color column.

Setting the Label

Drag the Sales field into the Label column. Then each column displays the sales value of each city.

Sort Based on the Sales Field

Hover the cursor over the City field in Horizontal Axis, and choose the drop-down icon > Descend > Sales to set the display of columns in descending order based on sales volumes.

Effect Display

On PC

The following figure shows the preview effect on PC.

On Mobile Terminals

The following figure shows the preview effect on the DataAnalyst app and in HTML5.

This section provides a method for adjusting the column spacing in a general column chart.

Adjust the column width and the spacing of mouse interaction category labels.

In conclusion, column charts are indispensable tools for visual data analysis, allowing for easy comparison of data across different periods or categories. Their straightforward format is ideal for quickly communicating changes in data, making them a valuable asset for business analytics, financial reporting, and strategic planning. Column charts enhance the understanding of data trends and facilitate informed decision-making.