How to create a composite chart in Excel

How to create a composite chart in Excel

Create a combined chart method in Excel

1. Position the cursor in the table area, switch to the Insert tab, and in the chart group, select more columns under Column chart.

2. Select the chart of the combined type in the open window, and then click the Custom Group button and select a chart type for each series below.

Create a combined chart method in Excel two

1, position the cursor in the table area, and then select the type of chart that most of the series will use to insert.

2. Select a series, click the right mouse button, and select "Change series chart Type" in the menu that pops up.

3. In the pop-up dialog box, set the appropriate chart type for each series.

The above two methods will get the same chart, the effect is as above.