- Image and text skills
When reporting year-end data, it is sometimes necessary to compare whether the data of each month meets the standards.
At this time, you can set the target reference line in the icon, so that you can easily tell whether the data in each month reaches the standard.
So how to insert target guides into the icon?
◾First, set up the standard data column and enter the standard data.
Select the data, then "Insert" - "All Charts" and select a chart, for example, select "Column Chart".
Select the "Attainment" series in the chart, right-click "Change Series Chart Type".
Set the "Attainment" type to "Line Chart" and click OK.
◾Finally select "Line Chart" and right-click "Format Data Series".
Fill the line, modify the width, and set the line type to "Dotted".
In this way, you can clearly distinguish whether the data of each month meets the standards.
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/nian-zhong-hui-bao-ji-qiao-ru-he-she-zhi-tu-biao-mu-biao-can-kao-xian.html
支付宝扫一扫 
评论列表（196条）
测试