:How to insert a combo chart-Table skills免费ppt模版下载-道格办公

How to insert a combo chart

  • Picture and text skills


When Sales Wang is preparing an annual summary report, he wants to create a chart of sales volume and sales growth.

The sales volume is a bar chart and the sales growth is a line chart. How to draw it?


0.gif


分界线.png

▪Taking this table as an example, select the data area and click Insert - All Charts in the upper menu bar.

The chart type dialog box will pop up, select "Combined Chart".


1.gif


▪We set the chart type of sales volume to clustered column chart, set sales growth to line chart, and check "Secondary axis".

Click OK to insert the combination chart.


2.gif


Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/ru-he-cha-ru-zu-he-tu-biao.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
single-end

Related Suggestion