210 likes | 221 Views
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.
E N D
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 Working with Charts Unit D
Objectives • Enhance a chart • Annotate and draw on a chart • Preview and print a chart Working with Charts Unit D
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
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
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
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
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
Creating a Chart (cont.) Column labels Legend Row labels Data range Chart object Y-axis X-axis Working with Charts Unit D
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
Moving and Resizing a Chart (cont.) Selection handle Common mouse pointers Working with Charts Unit D
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
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
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
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
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
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
Annotating and Drawing on a Chart (cont.) Annotation text Arrow Working with Charts Unit D
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
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
Previewing and Printing a Chart (cont.) Landscape page orientation Working with Charts Unit D