ITM 215 Class 17 Mar 23

ITM 215 Class 17 Mar 23 - ITM 215: Computer Applications in...

Info iconThis preview shows pages 1–15. Sign up to view the full content.

View Full Document Right Arrow Icon
Click to edit Master subtitle style ITM 215: Computer Applications in Charts and Graphics
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
New Perspectives on Microsoft Office Excel 33 Presentation Counts
Background image of page 3

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

View Full DocumentRight Arrow Icon
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
Background image of page 4
New Perspectives on Microsoft Office Excel Objectives Create an embedded chart Work with chart titles and legends 55
Background image of page 5

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

View Full DocumentRight Arrow Icon
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
Background image of page 6
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
Background image of page 7

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

View Full DocumentRight Arrow Icon
New Perspectives on Microsoft Office Excel In A Flash Charts, Images, Printing 88
Background image of page 8
New Perspectives on Microsoft Office Excel 99 Charts Enhance, summarize and communicate key points Effective chart – effectively conveys message 11 standard types of charts, sub-types (variations) and custom chart types
Background image of page 9

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

View Full DocumentRight Arrow Icon
New Perspectives on Microsoft Office Excel 1010 What’s The Message What are you trying to convey to the audience? Message, sales pitch, etc.
Background image of page 10
New Perspectives on Microsoft Office Excel 1111 Chart Types Always remember to keep it simple and clear Pie and Exploded pie charts are effective for displaying proportional relationships Column charts are used for displaying numbers Bar charts show numbers horizontally
Background image of page 11

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

View Full DocumentRight Arrow Icon
New Perspectives on Microsoft Office Excel 1212 Chart Types Three-Dimensional Pie Doughnut 100% Stacked Column Scatter Line Ribbon Radar Surface Stock Bubble
Background image of page 12
New Perspectives on Microsoft Office Excel 1313 Deciding What Chart is Best Present a Meaningful Graphic of Numeric Information to Support Effective Communication and/or Decision Making
Background image of page 13

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

View Full DocumentRight Arrow Icon
New Perspectives on Microsoft Office Excel Choosing the Right Type of Chart Pie Charts should be used only when
Background image of page 14
Image of page 15
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 56

ITM 215 Class 17 Mar 23 - ITM 215: Computer Applications in...

This preview shows document pages 1 - 15. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online