230 likes | 383 Views
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.
E N D
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 Working with Charts
Objectives • Format a chart • Enhance a chart • Annotate and draw on a chart • Preview and print a chart Working with Charts
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
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
Planning and Designing a Chart Common chart types Working with Charts
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
Planning and Designing a Chart (cont.) Data series Tick mark Plot area Category (y) axis Data marker Category (x) axis Working with Charts
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
Creating a Chart (cont.) Legend Column labels Row labels Data range Chart object Y-axis X-axis Working with Charts
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
Moving and Resizing a Chart (cont.) Selection handle Common mouse pointers Working with Charts
Editing a Chart • Changing data values in the worksheet automatically updates the chart Change value here… …see data marker change here Working with Charts
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
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
Enhancing a Chart • Create titles, add graphics, or add background color Drop shadow Gridline Value axis title Category axis title Working with Charts
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
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
Annotating and Drawing on a Chart (cont.) Annotation text Arrow Working with Charts
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
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
Previewing and Printing a Chart (cont.) Landscape page orientation Working with Charts
Summary • Plan your chart • Create the chart • Resize, move, and edit the chart • Enhance the chart • Preview and print the chart Working with Charts