How can excel quickly and easily insert pie charts to show your monthly consumption?

Excel has a lot of features, and it certainly doesn't matter if you generate a data visualization diagram. A pie chart is one of them. The following small series to introduce you to excel in how to quickly insert pie chart to show the month consumption method, take a look at it!

1, first we open the computer's Excel program.

2, in the Excel main interface to find the insertion button, select the bottom of the pie chart, as shown in the following figure.

3, then will pop down the box, we can choose the pie chart we need to show the way, two-dimensional or three-dimensional.

4, after the completion of the selection, you can see the main interface appears a blank white box, and the top of the menu bar will automatically jump to the design bar below, we can complete the pie chart, after the custom of our own pie chart color composition style.

5, next we add the relevant data information in the Excel table. Here I take one months of consumption as an example. After completing, we will move the mouse to the white box, right-click the mouse, select the right click menu under the selection of data, as indicated by the figure arrow.

6, pop-up Select Data Source dialog box, drag the mouse to select our last step to fill out the data area. Figures in the red box.

7, choose to complete the release of the mouse, we select a dynamic dotted around the area, and our Selection Data Source dialog box will appear in our selection of data. Click the OK button at the bottom right.

8, so that our pie-chart production even is completed. You can clearly see the one months of each consumption in the total consumption of the share. Through effective statistics of our monthly consumption ratio can also achieve wealth management effect OH.

The above is how Excel simple and quick Insert pie chart to show the month consumption method introduction, the method is very simple, have the need of friends can refer to this article Oh!