Microsoft Office Tutorials and References
In Depth Information
In this exercise, you’ll create a chart, change how the chart plots your data, move your chart
within a worksheet, and move your chart to its own chart sheet.
SET UP You need the YearlyPackageVolume workbook located in the Chapter09
practice file folder to complete this exercise. Open the workbook, and then follow the steps.
On the Data worksheet, click any cell in the Excel table, and then press Ctrl+* to
select the entire table.
In the lower-right corner of the Excel table, click the Quick Analysis button to display
tools available in the Quick Analysis gallery.
Click the Charts tab to display the available chart types.
Click Line to create the recommended line chart.
Press Ctrl+Z to undo the last action and remove the chart from your worksheet.
On the Insert tab, in the Charts group, click Bar and then, in the 2D Bar group, click
the first chart subtype, Clustered Bar . Excel creates the chart, with both the Year and
Volume data series plotted in the body of the chart.