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

524 Worksheet Charting 101
✦ Switch Row/Column: Click this button to immediately interchange the worksheet data used for the Legend Entries (series) with that used for the Axis Labels (Categories) in the selected chart.
✦ Select Data: Click this button to open the Select Data Source dialog box, where you can not only modify which data is used in the selected chart but also interchange the Legend Entries (series) with the Axis Labels (Categories), but also edit out or add particular entries to either category.
✦ Change Chart Type: Click this button to change the type of chart and then click the thumbnail of the new chart type on the All Charts tab in the Change Chart dialog box, which shows all kinds of charts in Excel.
✦ Move Chart: Click this button to open the Move Chart dialog box, where you move an embedded chart to its own chart or move a chart on its own sheet to one of the worksheets in the workbook as an embedded chart.
Modifying the chart layout and style
As soon as Excel draws a new chart in your worksheet, the program selects your chart and adds the Chart Tools contextual tab to the end of the Ribbon and selects its Design tab. You can then use the Quick Layout and Chart Styles galleries to further refine the new chart.
Figure 1-6 shows the original clustered column chart (created in Figure 1-5) after selecting Layout 9 on the Quick Layout button’s drop-down gallery and then selecting the Style 8 thumbnail on the Chart Styles drop-down gallery. Selecting Layout 8 adds Axis Titles to both the vertical and horizontal axes as well as creating the Legend on the right side of the graph. Selecting Layout 8 gives the clustered column chart its dark background and contoured edges on the clustered columns themselves.
Trying on all your choices in the Chart Styles gallery
When selecting a new style for your chart, you can display all the style choices by clicking that gallery’s More button (the one with the horizontal bar directly over a triangle pointing downward). Doing this displays the thumbnails of all your layout and style choices for the new
chart. You can also scroll through the rows of style choices by clicking the Previous Row or Next Row buttons immediately above it with the respective upward- or downward-pointing triangles.