轻松打造你的excel图表（Create your excel chart easily）.docVIP

轻松打造你的excel图表（Create your excel chart easily） Easy to build your Excel chart.Txt life, is used to run, rather than used to care about. Love is used to hold, not to test. Love is for love, not for hurt. Money is for enjoyment, not for measure. Lies are used to break, not to decorate. Trust is for precipitation, not for challenge. Easily build your Excel chart and easily build your Excel chart Wang Dong Zhu Meng I. convenient and flexible text box You can add removable text content anywhere in the diagram (not limited to the title). Method: select the chart, in addition to any part of the title or data series, then type the text content in the edit bar, and then press enter. In this way, a text box containing the typing content is automatically generated in the diagram. You can move it anywhere and change the format of the text box according to your preference. Two, the text box and cell link It introduces techniques for adding convenient and flexible text boxes to diagrams, and now shows how to link the contents of a worksheet cell with a chart text box. Enter text to link in the blank cell of the worksheet, click the chart in the input sign , and then click Edit bar = contains the cell that you want to link text, then press the Enter key, a position of the text will appear in the chart on the. Thus, whenever the text in the worksheet cell changes, the text in the diagram changes as well. Note, however, that once you have canceled the selected text box, it is difficult to use the mouse to select the text box for further modifications. You can move the chart element by using the arrow keys. Three, automatically update the smart chart In many cases, when we make a diagram, we often need to add new data points to the chart. Updating a charts reference data range is not difficult. As long as we use some special techniques, we can create an intelligent chart that automatically updates when you add or delete data points to the worksheet. The following example describes how