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

You can open the Insert Chart dialog box by clicking the Dialog Box launcher in lower-right corner of the Charts group on the Insert tab and then display the complete list of chart types by clicking the All Charts tab in this dialog box.
Inserting charts with the Quick Analysis tool
For those times when you need to select a subset of a data table as the range to be charted (as opposed to selecting a single cell within a data table), you can use the new Quick Analysis tool to create your chart. Just follow these steps:
1. Click the Quick Analysis tool that appears at the lower-right corner of the current cell selection.
Doing this opens the palette of Quick Analysis options with the initial Formatting tab selected and its various conditional formatting options displayed.
2. Click the Charts tab at the top of the Quick Analysis options palette.
Excel selects the Charts tab and displays its Clustered Bar, Stacked Bar, Clustered Column, Scatter, Stacked Column, and More Charts option buttons. The first five chart type buttons preview the selected data in
a different type of chart. The final More Charts button opens the Insert Chart dialog box with the Recommended Charts tab selected. Here you can preview and select a chart from an even wider range of chart types.
3. In order to preview each type of chart that Excel 2013 can create using the selected data, highlight its chart type button in the Quick Analysis palette.
As you highlight each chart type button in the options palette, Excel’s Live Preview feature displays a large thumbnail of the chart that will be created from your table data. (See Figure 1-4.) This thumbnail appears above the Quick Analysis options palette for as long as the mouse or Touch pointer is over its corresponding button.
4. When a preview of the chart you actually want to create appears, click its button in the Quick Analysis options palette to create it.
Excel 2013 then creates and inserts an embedded chart of the selected type in the current worksheet. This embedded chart is active so that you can immediately move it and edit it as you wish.
Worksheet Charting 101 521
Book V Chapter 1
Charting Worksheet Data