Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
charts and worksheets link Chart in the above-mentioned production process, charts of data series has been automatically and generate data in the table below link. Not only that, but the title of the chart, data labels, and even the additional title of picture and other information, can also establish a link with the cell, this could make the chart more dynamic. 1, the title of the link graph Chart title, axis title and classification of data such as axis title, in the use of the "Chart Wizard" to generate charts generally do not automatically link to any cell, unless artificially modified by hand. There are links to generate the title, first of all to ensure that the chart contains the data you need the title of the basic points, and if not, through the [Chart Wizard] to add the title to the chart. Select the title, and click the formula bar, type an equal sign, and then click on the title of the text contained in the cell or cells that enter this series of formula (such as: = Sheet1! $ A $ 1), enter the formula plus the title of the chart. As shown in Figure 6, the title of the cell A1 and the establishment of the link.  Figure 6 2, data link logo Excel allows to chart data points for each of the establishment of a label, There are two ways: one for manual operation, click and select all of the data symbol, and then click to select a data symbol, if a data symbol is selected, you can add text; another way, can a single cell to establish a link, that is, select the chart, in the formula bar to enter a formula (for example, = Sheet1! $ A $ 1). 3, the link text In general, the chart of the basic data points each corresponding to not only show that the cell type of the numerical data can also show that cells other text (such as descriptive text), which is achieved through the formula, that is required to select chart, in the formula bar enter an equal sign, and then click the cell that contains the text of the final return, the chart appeared in the middle of a text box in Figure 7, use the mouse to drag and arbitrary selection of favorite format. If the text entered into the formula bar will generate a cell does not establish a link with the text box. 
Figure 7 4, picture links If, when looking at a chart of all data points can also view the specific value, that is, data tables, see the chart on the more convenient. In the Chart Wizard Step 3 Select [Data Sheet] to edit options, which can display a chart of the numerical size of the points. However, the shortcomings of manual methods, once the format of the chart is set, the data table is always in a fixed position, and if too many data series are in the chart, it appears that scattered. |
