An easy way to make Excel charts

Data charting is a tool for visualizing boring numbers, the use of Excel icon making features can easily be such as a number of sample comparisons, trends, the proportion of the chart directly in the form of direct display, so that everyone can see the hidden behind the number of secrets, therefore, Charting data is also part of data mining, and here's a simple way to make an Excel chart.

First you have to prepare the basic data, then select the data, click the "Insert" menu, click "Icon", there will be "Chart Wizard", a total of four steps, follow the prompts of each step, make a choice, you can easily complete the production of Excel icon, the following we illustrate the answer, let you see in fact, the digital charting is also

The image above is a selection of the data area that you want to make the chart, and click the "Insert" icon after the prompt. In this step, you need to choose which type of diagram you want to generate, and each type of icon has its own advantages. At the same time, after choosing a large class, you need to select the appropriate form in the subclass on the right, and then click Next when you are finished with the large classes and subclasses. Below is a brief description of the main features and uses of the common chart categories.

The column chart is suitable for multiple data comparisons of multiple objects, such as the example above, the quarterly data comparisons across multiple industries, or the quarterly or monthly data comparisons of multiple subsidiaries;

The bar chart is the same as the column chart, but it is a column, but it is also suitable for multiple data comparisons.

"Line chart" is mainly used to express the change trend of one or more subjects, such as stock, expected value of production and so on;

"Pie chart" is mainly used to compare the proportion of different subjects at a certain point, such as the proportion of the questionnaire, and the contribution proportion of the subsidiary company in a January.

The XY scatter chart compares like a line chart, but is short the line;

The image above is step two: choose to generate a chart by rows or columns, you can select rows, you can select columns, and then look at the above preview effect, see which one is more suitable for your intention to express, choose the next step after clicking;

The above figure is step three: This step is to give the icon title and row and column coordinates (part of the icon style only the title, such as Pie), after the input will be on the right side of the preview area to show the effect;

The above figure is step four: the production of Excel icon is placed in this table or other tables, you can choose "as one of the objects inserted" after "sheet", default is placed in this table;

The chart above is a quarterly comparison chart set with a clustered column chart

Believe that through the above steps, you basically know the steps of Excel to make a table, you need to do is to try your own, and then modify the parameters of each step can be, hope that the triple Small series Ehoy provide these examples of information for everyone to help Oh!

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join