Microsoft Office Tutorials and References
In Depth Information
Chapter 10: Charming Charts and Gorgeous Graphics
1. Click the Quick Analysis tool that appears right below 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
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 how the selected data in a
different type of chart will look. 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
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. 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 a free-floating chart (called an embedded chart)
within the current worksheet. This embedded chart is active so that you
can immediately move it and edit it as you wish.
Figures 10-3 and 10-4 show you how this procedure works. In Figure 10-3, I’ve
selected only the first quarter sales figures (with their column headings) in
the much larger YTD spreadsheet. After selecting the range and clicking the
Quick Analysis tool that appears in the lower-right corner of the cell selection,
I clicked the Charts tab and then highlighted the Clustered Column chart type
button in the Quick Analysis tool’s option palette. The previewed clustered
column chart then appears in the thumbnail displayed above the palette.
Figure 10-4 shows you the embedded chart created by clicking the Clustered
Column chart type button in the Quick Analysis tool’s palette. When first
created, the new chart is active and its chart area is automatically selected. When
this is the case, you can move the entire chart to a new part of the worksheet
by dragging it. While the chart area is selected, Excel outlines and highlights
the data represented in the chart in red for the headings used in the chart
legend, in purple for the headings used as labels along the horizontal, Category
or x-axis, and in blue for the values represented graphically by the bars in
the chart and in the vertical, Value or y-axis. In addition, the Chart Tools
contextual tab with its Design and Format tabs are added to the Ribbon and the
Design tab, with its options for making further design changes, is selected.