Page 552 - Excel 2013 All-in-One For Dummies

534 Worksheet Charting 101
To remove all data labels from the data points in a selected chart, clear the Data Labels check box on the Chart Elements menu.
Adding a data table to a chart
Sometimes, instead of data labels that can easily obscure the data points in the chart, you’ll want Excel to draw a data table beneath the chart showing the worksheet data it represents in graphic form.
To add a data table to your selected chart and position and format it, click the Chart Elements button next to the chart and then select the Data Table check box before you select one of the following options on its continuation menu:
✦ With Legend Keys to have Excel draw the table at the bottom of the chart, including the color keys used in the legend to differentiate the data series in the first column
✦ No Legend Keys to have Excel draw the table at the bottom of the chart without any legend
✦ More Options to open the Format Data Table task pane on the right side where you can use the options that appear when you select the Fill & Line, Effects, Size & Properties, and Table Options buttons under Table Options and the Text Fill & Outline, Text Effects, and Textbox buttons under Text Options in the task pane to customize almost any aspect of the data table
Figure 1-10 illustrates how the sample clustered column chart (introduced in Figure 1-6) looks with a data table added to it. This data table includes the legend keys as its first column.
If you decide that having the worksheet data displayed in a table at the bottom of the chart is no longer necessary, simply click to deselect the Data Table check box on the Chart Elements menu.
Editing the chart titles
When Excel first adds any title to a new chart, the program gives it a generic name, such as Chart Title or AXIS TITLE (for both the x- and y-axis title). To replace such generic titles with the actual chart titles, click the title in the chart or click the name of the title on the Chart Elements drop-down list. (Chart Elements is the first drop-down button in the Current Selection group on the Format tab under Chart Tools. Its text box displays the name of the element currently selected in the chart.) Excel lets you know that a particu- lar chart title is selected by placing selection handles around its perimeter.