How Excel makes column graphs of average, standard deviation

Today's Excel tutorial tells you a way to let us design a form to build a style that is convenient for the next use.

The specific self-built operation process is as follows:

1, start Excel2007, import the source data table, click the menu bar--Start--Apply Table style--new table style.

2, new table style, first to specify the style name, in the table elements we can set a one, click the format can enter the Setup interface.

3, set the cell format, in the font, we will change the font color gray.

4, then switch to the Border tab, set the border style, and color.

5, I will not be one by one to demonstrate, we can free and arbitrary collocation, small series is not shortcoming.

6, after setting up, how to use it? Still, click the Apply Table Style button, and in the first customization we can see the style that was previously set.

7, click on it, apply, so that our previous data table has become the style of their own settings, this style can be saved to Excel, the next time you do not need to set the use, directly apply.