How to make a personality chart in Excel2013?

I'm sure everyone will insert a chart in the Excel2013, but do you want to make your chart look more creative and be able to stand out in a number of charts? What's going on today is how to make a personal chart in the Excel2013. Of course, this is a beginner and master is applicable to the tutorial, because we start from the beginning.

The specific steps are as follows:

1, we use Excel2013 open a worksheet with data, select the cells that need to be reflected in the chart, switch to the Insert tab, and perform the recommended charts command.

2, there will be a "Insert Chart" dialog box, and has been switched to the "Recommended Charts" tab, you select a chart, we now select "Clustered Bar", and then click the OK button.

3, back to the worksheet, we can see that we have inserted a clustered bar, select "Chart title", and then press the DELETE key to delete it.

4, now, we modify the bar chart fill the graph, first select a blue bar in the picture, when all the blue bars are in the selected state, press the right mouse button, in the pop-up menu, select the "Format data series" option.

5, at this time the right side of the window will be a "Set data series format" pane, we switch to the Fill tab, select the picture or texture fill option, and then drag down the scroll bar to the right of the Fill tab, locate the Insert Picture from item, and click the File button.

6, at this time will pop up a "Insert Picture" window, everyone in the right place to choose their own pictures, for example, we now select the "desktop" in the "Picture material" folder called "Gold coin. jpg" Picture, and then click the Insert button.

7, now the blue bar in the picture has become the picture we have chosen, but it is elongated, it is not clear at all, we can continue to drag the scroll bar to the right of the pane, and then select the Cascade option.

8, switch to the "Series Options" tab, the "Classification spacing" to reduce the point, so that the picture can be more clear, we modify it to "2%", and then click the Set Data series format pane in the upper right corner of the close button.

9, back to the worksheet, we now add data labels to the bar, continue to navigate to the fill graph, right-click, select the Add data labels Group, "Add data Labels" option.

10, you can see that the bar has been added to the corresponding data, now, we select the bar chart in the interval line, press the DELETE key to remove it.

11, there is no spacer line, you can now modify the font format of one or several data, so that it can be highlighted, for example, we select the largest data, switch to the "Start" tab, change the "font size" to 12, and click the "Bold" button.

12. Now, we will adjust the starting and ending values of the horizontal axis in the graph, select the horizontal axis, right-click, and select the format axes option in the Drop-down menu that pops up.

13, the right side of the window will pop up a "format axis" pane, and has switched to the Axis Options tab, you can modify the boundary group of the "minimum" and "maximum", we will change the minimum value to "500.0", and then click the Close button to close the pane.

14, return to the worksheet, our personalized chart has been made, you are satisfied with it?

Hint: We have only done a case here, we have learned the method can be free to play.

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