Microsoft Office Tutorials and References
In Depth Information
To set the size of the charts:
1. Click the Scale to fit page option button, and then click the OK button. The Use full page
option and the Scale to fit page option will often result in charts that are close in the same
size. You may not see much difference in the chart size in the Print Preview window.
2. Click the Next button to preview the column chart printout.
3. Click the Setup button, click the Scale to fit page option button on the Chart tab, and
then click the OK button.
4. Click the Print button to open the Print dialog box, make any necessary changes, and then
click the OK button to send both chart sheets to the printer.
For now, there are no other changes to be made. Alicia will use the printouts of the charts
at the meeting next week.
5. Save your changes to the workbook and then close it
Session 4.2 Quick Check
1. How would you remove a data series from a column chart?
2. How would you change the location (either embedded or as a chart sheet) of a chart?
3. What is the difference between label text, attached text, and unattached text?
4. What is the difference between major tick marks and minor tick marks?
5. How would you change a column chart into a 3-D column chart?
6. What is an AutoShape?
7. Describe the three options for sizing a chart on the printed page.
To reinforce the tasks you
learned in this session,
go to the SAM 2003
Training Companion CD
included with this text.
In this tutorial, you learned how to work with charts in Excel. You saw how to use Excel’s
Chart Wizard to create a basic chart and learned about the different types of charts that can
be created by Excel. You also learned how to embed charts within a worksheet or place
them on their own chart sheet in the workbook. You used Excel’s editing tools to modify the
chart’s appearance by inserting additional text, changing font and background colors and
images, rotating the chart in three dimensions, and changing the scale of the chart. This tuto-
rial also introduced you to the Drawing toolbar, which you used to create an AutoShape,
placing that shape on a chart to provide additional emphasis on key points. Finally, you
learned about the different options Excel provides for printing your completed charts.
exploded pie chart