1 / 23

Microsoft Office 2003- Illustrated Introductory, Premium Edition

Microsoft Office 2003- Illustrated Introductory, Premium Edition. Working. with Charts. Objectives. Plan and design a chart Create a chart Move and resize a chart Edit a chart. Objectives. Format a chart Enhance a chart Annotate and draw on a chart Preview and print a chart.

judith-holt
Download Presentation

Microsoft Office 2003- Illustrated Introductory, Premium Edition

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Microsoft Office 2003- Illustrated Introductory, Premium Edition Working with Charts

  2. Objectives • Plan and design a chart • Create a chart • Move and resize a chart • Edit a chart Working with Charts

  3. Objectives • Format a chart • Enhance a chart • Annotate and draw on a chart • Preview and print a chart Working with Charts

  4. Unit Introduction • Worksheets are not always the best way to present data to others • Information in a range or worksheet can be displayed in a chart • Charts allow you to communicate the relationships in worksheet data using pictures Working with Charts

  5. Planning and Designing a Chart • Chart planning guidelines • Determine purpose of chart • Identify data relationships • Determine results with chart type • Identify worksheet data • Sketch the chart and decide on chart elements Working with Charts

  6. Planning and Designing a Chart Common chart types Working with Charts

  7. Planning and Designing a Chart (cont.) • Chart elements • The horizontal axis (x-axis) is also called the category axis • The vertical axis (y-axis) is also called the value axis • Area inside the axis is called the plot area • The scale of measure on the y-axis is identified by tick marks • A data point is the value in a cell • A data marker represents the data point in the chart • A group of related data points is a data series Working with Charts

  8. Planning and Designing a Chart (cont.) Data series Tick mark Plot area Category (y) axis Data marker Category (x) axis Working with Charts

  9. Creating a Chart • To create a chart, first select a range of data • Use the Excel Chart Wizard to create a chart • Choose the chart type • Choose the data to chart and how it appears • Add chart options • Determine chart placement • Can create a chart sheet, a separate sheet containing just the chart Working with Charts

  10. Creating a Chart (cont.) Legend Column labels Row labels Data range Chart object Y-axis X-axis Working with Charts

  11. Moving and Resizing a Chart • A chart is a graphic, or drawn object, and is not located in a specific cell or range • An object is an independent element on a worksheet • An object can be moved anywhere on the worksheet without affecting formulas or data • Resize a chart by moving a selection handle; move a chart by dragging it Working with Charts

  12. Moving and Resizing a Chart (cont.) Selection handle Common mouse pointers Working with Charts

  13. Editing a Chart • Changing data values in the worksheet automatically updates the chart Change value here… …see data marker change here Working with Charts

  14. Editing a Chart (cont.) • Rotating a 3-D chart • Other data series in the same chart can obscure columns or bars • Rotate the chart to get a better view by dragging the Corners object Corners object Working with Charts

  15. Formatting a Chart • Change a chart’s appearance by formatting it • The horizontal and vertical lines in a chart are called gridlines Change data series color Gridline Working with Charts

  16. Enhancing a Chart • Create titles, add graphics, or add background color Drop shadow Gridline Value axis title Category axis title Working with Charts

  17. Enhancing a Chart (cont.) • Changing text alignment in charts • Change text alignment of axis text to fit better in plot area • Double-click the axis to be modified, click the Alignment tab in the Format Axis dialog box, then change the degree number Working with Charts

  18. Annotating and Drawing on a Chart • A text annotation is a label that you add to a chart to further describe data • Use lines and arrows to point out exact locations you want to emphasize • Typing text in the formula bar creates annotation text Working with Charts

  19. Annotating and Drawing on a Chart (cont.) Annotation text Arrow Working with Charts

  20. Annotating and Drawing on a Chart (cont.) • Exploding a pie slice • Emphasize a pie slice in a pie chart • Click and drag the desired pie slice Exploded pie slice Working with Charts

  21. Previewing and Printing a Chart • Before printing, it’s a good idea to preview your chart • When you preview a chart, you see a copy of the chart exactly as it will appear on paper • The landscape page orientation runs text the long way on the page Working with Charts

  22. Previewing and Printing a Chart (cont.) Landscape page orientation Working with Charts

  23. Summary • Plan your chart • Create the chart • Resize, move, and edit the chart • Enhance the chart • Preview and print the chart Working with Charts

More Related