:"Year-end report production: using color contrast to highlight key data indicators"-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. "Year-end report production: using color contrast to highlight key data indicators"

"Year-end report production: using color contrast to highlight key data indicators"

Author: daogeziyuan • • Table skills • Views 742
Of course, the following is the rewritten content, retaining the HTML and image address information in the original text: ```html
  • Graphic skills

In the last issue, we explained how to distinguish whether the data meets the standard by setting reference lines on the chart.

In this issue we introduce another method: setting different colors for chart data.

Take the following data table as an example, assuming that our standard data is 2000.

0.gif

First, we insert two auxiliary columns, namely the standard column and the non-standard column.

In the standard column, we use the formula =IF(B2>=2000,B2,0).

This means that if the data of B2 is greater than or equal to 2000, then display the data, otherwise display 0.

In the underachievement column, we use the formula =IF(B2<2000,B2,0).

This means that if the data of B2 is less than 2000, then display the data, otherwise display 0.

1.gif

Then, we select the data area and insert a column chart.

Click on the chart, right-click and select "Select Data", and uncheck the data in column B.

2.gif

Next, we may find that the bars in the column chart are unevenly distributed.

Select any data series and right-click "Format Data Series."

Enter 100% in "Series Overlap" to evenly space the columns.

In this way, we can visually show whether the data meets the standards through the different colors of the data in the chart.

3.gif

```Please note that this content has been rewritten to more smoothly convey the message of the original text, while retaining the original HTML structure and image links.

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-bao-gao-zhi-zuo-yun-yong-se-cai-dui-bi-tu-xian-guan-jian-shu-ju-zhi-biao.html

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

Related Suggestion