How to draw a column chart in WPS Spreadsheet

Uploaded time: 2021-08-31 Difficulty: Primary

How to draw a column chart in WPS Spreadsheet

How to draw a column chart in WPS Spreadsheet

Graphic skills

A Column chart can help us to visually compare data differences and is also one of the chart styles often used in work.


Take this table as an example, how can we quickly compare the differences in sales of each country each country's sales?

1. Click Insert, click Chart, and click Column.

Gif (1).gif


2. Click the column with the mouse, and then the editing window will pop up on the right. Then, we can modify the color of the column in FILL&LINE.  

Gif (2).gif


3. Click SERIES. We can adjust the gap between the columns in the Series Overlap, and the width of the columns can be adjusted in the Gap Width.

Gif (3).gif 

Now we find that we cannot clearly see the differences between data clearly in this chart because the sales in several countries are very close. In this situation, we can double-click the ordinate axis to pup up an editing window on the right.

1. Click AXIS OPTIONS, and then choose Axis. Then, we can adjust Minimum in Bounds.

Since the sales of all countries have exceeded 500,000, we can enter 500000 here to change the height of the column.

Gif (4).gif


2. Now, click Add Chart Element and select Data Labels.

In this way, we can see the differences between data very intuitively.

Gif (5).gif


We can also make separate comparisons for the sales of some countries.

1. Click Chart Filters on the right of the chart.

2. Check the month and country of the required data. In this way, we can compare the data we want quickly.

Gif (6).gif


To be office excel advancers, we could learn how to use WPS Office Spreadsheet online in WPS Academy.