As we all know, Excel is the continent of data, but in fact, it is not only in the use and analysis of data is the Office software in the lead, in the display of data, it is not to be outdone. What we are going to learn today is to use the data bar in the Excel2013 to visualize the way the data is presented.
The following are specific practices:
1, with Excel2013 open a worksheet containing data, we use the following figure as an example, in column C to show the data in column B. First we select the C3 cell, enter the formula "=B3" in it, and press ENTER.
2, move the mouse to the lower right corner of cell C3, when the cursor becomes black cross state, press the left mouse button, and drag down until automatically fill the C column needed cells, we release the mouse.
3. Select the C3 to C10 cell, switch to the Start tab, click the Data Bar option in the conditional Formatting group, and select the bar style you want in the Drop-down menu that pops up.
4, back to the worksheet, our C column has been filled with data bar, if you do not want the data in column C, you can perform the conditional formatting group, "Management rules" command.
5, a Conditional Formatting Rule Manager dialog box pops up, and we click the Edit Rule button.
6. In the "Edit Formatting Rule" dialog box that pops up, we check the "Show Data bar only" option in the Edit Rule description area, and then click OK.
7, return to the Conditional Formatting Rule Manager dialog box, we click the OK button again.
8, OK, our data bar has been completed, the final effect is as follows.
Tip: The data bar is mainly used to show a piece of data, if we have a few sets of data to show, then you can try to use the Mini map to achieve.
Note : More wonderful tutorials Please pay attention to the triple Office software tutorial section, triple Computer office group: 189034526 welcome you to join