How to make a combination chart in Excel How to make a combination chart in Excel

Many friends fill in a lot of data when using Excel forms. To display multiple data in the same data chart, you need to make a combination chart. Many people don’t know how to make it. For this Question, today’s software tutorial will share the operation method with the majority of users, hoping to bring help to everyone. How to make a combination chart in Excel: 1. First, open Excel, drag the mouse to select the data area for making the chart, click the insert option above the main interface, then click the expand icon in the lower right corner of the chart area, and in the pop-up dialog box for inserting the chart Click on all the charts above, and then click on the combination chart at the bottom of the left column. Then first select a combination chart type at the top of the right area. 2. There are four combination types. The first is a clustered column chart-line chart, the second is a clustered column chart-line chart on the secondary axis, and the third is a stacked area chart-clustered column. Graphics, the fourth is a custom combination. Everyone can choose the combination type according to their own needs. Here we take the clustered column chart-line chart as an example.

3. Then see the series name below. Since the first clustered column chart-line chart combination chart type has been selected in the previous step, clustered column is automatically selected for series one. Line chart, series 2 automatically selects the line chart, we can also click to expand to make changes, and we can also choose to check the secondary axis behind series 1 and 2. The above are all based on the needs of data type to make a choice. After setting, click OK.

4. The combination chart will pop up. Double-click the chart title to rename the title. Click the first small icon on the right side of the combination chart to add elements to the chart. You can check as needed. .

5. Click the second icon on the right side of the chart to set the style and color of the chart to make the chart more beautiful.

The above is the detailed content of How to make a combination chart in Excel How to make a combination chart in Excel. For more information, please follow other related articles on the PHP Chinese website!