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

532 Worksheet Charting 101
Table 1-2 (continued)
Tab Group
Size
Option Name
Shape Height
Shape Width
Purpose
Use this text box to modify the height of the selected embedded chart by typing a new value in it or selecting one with the spinner buttons.
Use this text box to modify the width of the selected embedded chart by typing a new value in it or selecting one with the spinner buttons.
Customizing the elements of a chart
The Chart Elements button (with the plus sign icon) that appears in the upper-right corner of your chart when it’s selected contains a list of the major chart elements that you can add to your chart. To add a particular ele- ment missing from the chart, select the element’s check box in the list to put a check mark in it. To remove a particular element currently displayed in the chart, deselect the element’s check box to remove its check mark.
To add or remove just part of a particular chart element or, in some cases as with the Chart Title, Data Labels, Data Table, Error Bars, Legend, and Trendline, to also specify its layout, you select the desired option on the ele- ment’s continuation menu. (See Figure 1-9.)
So, for example, to reposition a chart’s title, you click the continuation button attached to Chart Title on the Chart Elements menu to display and select from among the following options on its continuation menu:
✦ Above Chart to add or reposition the chart title so that it appears centered above the plot area
✦ Centered Overlay to add or reposition the chart title so that it appears centered at the top of the plot area
✦ More Options to open the Format Chart Title task pane on the right side of the Excel window so you can use the options that appear when you select the Fill & Line, Effects, and Size and Properties buttons under Title Options and the Text Fill & Outline, Text Effects, and the Textbox but- tons under Title Options in this task pane to modify almost any aspect of the title’s formatting