How to stick two columns together in a column chart made by EXCEL?

First, click on the computer desktop to open the excel spreadsheet software, and then open the relevant files in this software. Then click the Insert tab on the page, and then click the Column Chart option in the options below.

Select "Format Data Series" in the pop-up menu and see "Category Spacing", where you can adjust the column spacing.

How to stick two columns together in a column chart made by EXCEL? Select "Format Data Series" in the pop-up menu and see "Category Spacing", where you can adjust the column spacing.

Select the data, and then click Insert Column Chart to get a column chart. Place the mouse on the column chart you just got, right-click, and then click Select Data. Click the Add button in the picture that appears.

Set the data series format-series option, there is a classification interval that can be adjusted, and when it is adjusted to 0, it will be combined to change the color. In data series format filling, you can modify the color according to your preference. Column charts are used to show data changes over a period of time or to show comparisons between items.

Open the EXCEL form and enter the data you need. Objective: The column chart shows the number of people leaving three departments in the first half of the year, and the line chart shows the total number of people leaving each month. Select the whole cell (including the column of the total number of people you need to make a line chart).