1 / 21

Microsoft Office XP Illustrated Introductory, Enhanced

Microsoft Office XP Illustrated Introductory, Enhanced. Working. With Charts. Objectives. Plan and design a chart Create a chart Move and resize a chart Edit a chart Format a chart. Objectives. Enhance a chart Annotate and draw on a chart Preview and print a chart. Unit Introduction.

lydiablackwell
Download Presentation

Microsoft Office XP Illustrated Introductory, Enhanced

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 XP Illustrated Introductory, Enhanced Working With Charts

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

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

  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 Unit D

  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 Common chart types Working with Charts Unit D

  6. 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 Unit D

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

  8. 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 Unit D

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

  10. 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 Unit D

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

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

  13. Editing a Chart (cont.) • Rotating a 3-D chart • In a three-dimensional 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 Unit D

  14. 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 Unit D

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

  16. 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 Unit D

  17. 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 Unit D

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

  19. 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 Unit D

  20. 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 Unit D

  21. Previewing and Printing a Chart (cont.) Landscape page orientation Working with Charts Unit D

More Related