Detailed method to add line chart effect on top of bar chart in excel2016 chart

As shown in the figure, it is the original data. Column A is the name of the province and city, column B is the lower-level address, and column C is the mapping data.

Insert a blank row between the two first-level addresses in column A, so that the graphics in the two regions in the chart are separated and will not be connected together.

Select all data areas and select [Insert]-[Chart]-[Area Chart].

The default generated chart style is as follows, the data in column C is displayed in blue as a series:

Copy the data in column C of the original area, and add it to the chart Right-click the area and select [Paste].

In this way, a new red graphic series will be added to the chart, coinciding with the original blue area.

Select the red series data and change the chart type to a line chart by right-clicking the mouse.

Select [Line Chart with Data Markers] in the line chart, and then confirm.

In this way, the blue area chart forms a result similar to a bar chart, and the same series of data forms a line chart with data markers above the blue chart.

Slightly adjust the format of the chart, and the final rendering is as follows:

The above is the detailed content of Detailed method to add line chart effect on top of bar chart in excel2016 chart. For more information, please follow other related articles on the PHP Chinese website!