Home >Software Tutorial >Office Software >Steps to create a mixed line and column chart in PPT

Steps to create a mixed line and column chart in PPT

王林
王林forward
2024-03-26 21:26:48835browse

php Xiaobian Yuzai will introduce you in detail the steps to create a mixed line and column chart in PPT. In PPT, mixed line and column charts can visually display data change trends, making the presentation more vivid and powerful. First, select the data source and insert the chart, then adjust the chart type to a hybrid chart if necessary. Next, set up the line and column data series, adjust the colors and styles, and finally add data labels and legends to improve the readability of the chart. With a few simple steps, you can create a beautiful and practical mixed line and column chart, making your PPT more attractive and persuasive.

1. Insert the data chart into the PPT and select [Clustered Column Chart] as the type.

Steps to create a mixed line and column chart in PPT

2. Enter the source data and use only two columns of data. For example, the first column is monthly data and the second column is monthly cumulative data.

Steps to create a mixed line and column chart in PPT

3. To change the chart type of the cumulative data series, click "Change Chart Type" under Chart Tools, click [Combine], select the line chart with data markers for the cumulative data, and check Secondary coordinate axis.

Steps to create a mixed line and column chart in PPT

4. After clicking OK, the basic combination graph is obtained.

Steps to create a mixed line and column chart in PPT

5. Add column chart and line chart Data labels. And set different colors to show distinction.

Steps to create a mixed line and column chart in PPT

6. Further beautify the data chart, delete unnecessary elements, highlight the information, and obtain the final chart.

Steps to create a mixed line and column chart in PPT

The above is the detailed content of Steps to create a mixed line and column chart in PPT. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:zol.com.cn. If there is any infringement, please contact admin@php.cn delete