Necessary in the workplace: Excel2016, the official recommended the use of skills

Skill

shujufenxi· 2016-07-30 13:11:30

learn to use Excel mapping table in order to allow the data to be more intuitive to show, is one of the essential skills of the work. />

Excel


chart:


to select the table, click [insert] - [waterfall map].

.

click the chart title, enter the title of the chart. />



click [format] [] - shape filling [green], select.


finally delete the legend entry and grid line, set the fill color, finish:


two, the

sun is very suitable for display hierarchical data graph. Each level of the

hierarchy is represented by a ring or circle, and the innermost circle represents the top level of the hierarchy.


steps:

1. select all data in the table, click [insert] [map] - sun.


click [title] chart, input chart title.


select Insert chart, click the [design] - [] can change the chart styles, insert chart style. />


tree diagram provides a hierarchical view of the data, the tree branch is represented as a rectangle, each sub branch is shown as a smaller rectangle. Tree graphs are used to compare the relative size of the data in a hierarchical structure. />


1. select all the data in the table, click Insert - [tree].


click [title] chart, input chart title.


. select Insert chart, click the [design] - [chart styles] choose a style.

to select any data label on the chart, select the value in the Settings tab format pane".


final effect:


four, Platon

is used to find problems or affect the quality of the main reason, it can highlight the biggest factor of a set of data, is regarded as one of the seven basic quality control tools. />


select all the data in the table, click Insert - [alignment chart].


select Add to the chart, click the [design] - [] can change the chart styles, insert chart style. Change chart name.

(end)

source: ExcelHome   according to Zhu Hongzhong @ Microsoft help and support micro-blog

copyright statement the content from the Internet, please indicate the original link and, if any infringement or source is incorrect please contact us.


1249

"text-align: center;" >484

style= "font-size: 14px has 136 project in micro chain financing success

  not quick to download!


please click on the "

data analysis (ecshujufenxi)

The lastest articles of shujufenxi

Dry cargo: the complete knowledge structure of Data Analyst

Necessary in the workplace: Excel2016, the official recommended the use of...

Necessary in the workplace: Excel2016, the official recommended the use of...

Dry cargo: ten points of the website segment analysis

Dry cargo: ten points of the website segment analysis

Business analysis to achieve business insight - Excel business intelligence...

Business analysis to achieve business insight - Excel business intelligence...

About the data analysis of those things, look at this article is enough

About the data analysis of those things, look at this article is enough

How

Discussion: how big data will change your life