New Perspectives on Microsoft Office Excel 22 Overview • Business graphics one of most exciting Windows applications • Determine message of chart • Plot multiple data sets on a single chart • Dynamically link a chart to a memo

New Perspectives on Microsoft Office Excel 33 Presentation Counts

This preview
has intentionally blurred sections.
Sign up to view the full version.

New Perspectives on Microsoft Office Excel 44 Objectives • Know advantages and disadvantages of different chart types • Distinguish between an embedded chart and one in a separate chart sheet • Differentiate between data series specified in rows Versus ones in columns

New Perspectives on Microsoft Office Excel Objectives • Create an embedded chart • Work with chart titles and legends 55

This preview
has intentionally blurred sections.
Sign up to view the full version.

New Perspectives on Microsoft Office Excel 66 What is a Chart? • A graphic or visual representation of data in a worksheet • Based on descriptive (text) entries called category labels and numeric values called data points • Data series: a grouping of data points

New Perspectives on Microsoft Office Excel Creating Charts • Select the data source with the range of data you want to chart • In the Charts group on the Insert tab, click a chart type, and then click a chart subtype in the Chart gallery • In the Location group on the Chart Tools Design tab, click the Move Chart button to place the chart in a chart sheet or embed it into a worksheet 77

This preview
has intentionally blurred sections.
Sign up to view the full version.