:Beginner’s tutorial on tables Commonly used charts Target and actual comparison chart-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. Beginner’s tutorial on tables Commonly used charts Target and actual comparison chart

Beginner’s tutorial on tables Commonly used charts Target and actual comparison chart

Author: daogeziyuan • • Table skills • Views 549
  • Image and text skills


In our daily work, we often set goals and then check the actual completion status against the goals.


图片1.png


So, how to create a comparison chart between target and actual in the WPS table?

 

图文对齐图.png


First prepare the table data.


￭ In the first step, select the data area, click "Insert" - "Chart" and select "Clustered Column Chart".


 录制_2019_09_17_11_20_14_132.gif


￭ In the second step, double-click the "actual" graphic in the chart and set the "secondary axis" in the task pane that appears on the right.

Adjust the series overlap to 100% and adjust the appropriate category spacing.

 

录制_2019_09_17_11_20_36_729.gif


￭ The third step is to unify the scales of the coordinate axes.

Adjust the maximum scale to the largest number in the two axes.

Double-click the left coordinate axis, set the maximum axis value to 200 in the task pane, and then delete the secondary coordinate axis on the right.

The completed effect is as shown below:

 

录制_2019_09_17_11_20_57_643.gif


It is very intuitive to see the comparison between the target and the actual situation.


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/biao-ge-xin-shou-jiao-cheng-chang-yong-tu-biao-mu-biao-yu-shi-ji-dui-bi-tu.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu 梦游仙 Columnist
48 196
single-end

Related Suggestion