Excel question: How to realize the histogram and line chart in this table?

The first step is to select the actual and planned recruitment numbers and insert a bar chart. Select the actual number of people on the secondary shaft.

In the second part, the main ordinate axis and the secondary ordinate axis are arranged in reverse order, thus adjusting the order of the table.

Step 3, choose orange, transparency 100%, gap width 80%, black border, thin lines, and can be slightly shaded;

Check the blue box, and the gap width is120%; Adjust the chart to be unfilled and borderless; Delete axes, gridlines, legends and titles.

Step 4: Hold down Alt+ mouse and drag the two corners of the chart to anchor it in the desired cell in column D..

Aesthetically, I'll tidy it up a little. Line charts need camera function, and can be rotated after being drawn. In the same way.