New Perspectives on Microsoft Excel 2019 Carey Pinard Shaffer Shellman Vodnik New Perspectives Collection Microsoft Office 365 Office 2019 1st Edition 2020 Cengage All Rights Reserved May not be scanned copied or duplicated or posted to a publicly accessible website in whole or in part Module 4 Analyzing and Charting Financial Data Carey Pinard Shaffer Shellman Vodnik New Perspectives Collection Microsoft Office 365 Office 2019 1st Edition 2020 Cengage All Rights Reserved May not be scanned copied or duplicated or posted to a publicly accessible website in whole or in part Objectives Part 1 Create a pie chart Format chart elements Create a line chart Work with chart legends Create a combination chart Carey Pinard Shaffer Shellman Vodnik New Perspectives Collection Microsoft Office 365 Office 2019 1st Edition 2020 Cengage All Rights Reserved May not be scanned copied or duplicated or posted to a publicly accessible website in whole or in part Objectives Part 2 Create a scatter chart Edit a chart data source Create a data callout Insert shapes and icons into a worksheet Create and edit a data bar Create and edit a group of sparklines Carey Pinard Shaffer Shellman Vodnik New Perspectives Collection Microsoft Office 365 Office 2019 1st Edition 2020 Cengage All Rights Reserved May not be scanned copied or duplicated or posted to a publicly accessible website in whole or in part Visual Overview Chart Elements Carey Pinard Shaffer Shellman Vodnik New Perspectives Collection Microsoft Office 365 Office 2019 1st Edition 2020 Cengage All Rights Reserved May not be scanned copied or duplicated or posted to a publicly accessible website in whole or in part Getting Started with Excel Charts Part 1 Charts show trends or relationships in data that are easier to see in a graphic representation rather than viewing the actual numbers or data Excel has more than 60 types of charts organized into the 10 categories described in Figure 4 1 Within each chart category are chart variations called chart subtypes You can also design custom chart types to meet your specific needs Carey Pinard Shaffer Shellman Vodnik New Perspectives Collection Microsoft Office 365 Office 2019 1st Edition 2020 Cengage All Rights Reserved May not be scanned copied or duplicated or posted to a publicly accessible website in whole or in part Getting Started with Excel Charts Part 2 Creating a Chart o Select the range containing the data you want to chart o On the Insert tab in the Charts group click the Recommended Charts button or a button representing the general chart type and then click the chart you want to create or click the Quick Analysis button click the Charts category and then click the chart you want to create o On the Chart Tools Design tab in the Location group click the Move Chart button select whether to embed the chart in a worksheet or place it in a chart sheet and then click OK o Use the chart tools to format the appearance of individual chart elements Carey Pinard Shaffer Shellman Vodnik New Perspectives Collection Microsoft Office 365 Office 2019 1st Edition 2020 Cengage All Rights Reserved May not be scanned copied or duplicated or posted to a publicly accessible website in whole or in part Getting Started with Excel Charts Part 3 Figure 4 1 Excel chart types and subtypes Chart Category Column or Bar Chart Subtypes 2 D Column 3 D Column 2 D Bar 3 D Bar Hierarchy Description Compares values from different categories Values are indicated by the height of the columns or the length of a bar Display data that is organized into a hierarchy of categories where the size of the groups is based on a number Displays financial cash flow values or stock market data Waterfall or Stock Line or Area Compares values from different categories Values Statistic are indicated by the height of the lines Often used to show trends and changes over time Displays a chart summarizing the distribution of values from a sample population Treemap Sunburst Waterfall Funnel Stock 2 D Line 3 D Line 2 D Area 3 D Area Histogram Pareto Box and Whisker Carey Pinard Shaffer Shellman Vodnik New Perspectives Collection Microsoft Office 365 Office 2019 1st Edition 2020 Cengage All Rights Reserved May not be scanned copied or duplicated or posted to a publicly accessible website in whole or in part Getting Started with Excel Charts Part 4 Figure 4 1 Excel chart types and subtypes Chart Category Pie Chart Subtypes 2 D Pie 3 D Pie Doughnut Description Compares relative values of different categories to the whole Values are indicated by the areas of the pie slices Shows the patterns or relationship between two or more sets of values Often used in scientific studies and statistical analyses Compares three sets of values in a three dimensional chart Combines two or more chart types to make the data easy to visualize especially when the data is widely varied Compares data values across geographical regions Creates a chart summarizing data from a PivotTable X Y Scatter or Bubble Surface or Radar Combo Map PivotChart Scatter Bubble Surface Radar Clustered Column Line Clustered Column Line on Secondary Axis Stacked Area Clustered Column Filled Map PivotChart PivotChart PivotTable Carey Pinard Shaffer Shellman Vodnik New Perspectives Collection Microsoft Office 365 Office 2019 1st Edition 2020 Cengage All Rights Reserved May not be scanned copied or duplicated or posted to a publicly accessible website in whole or in part Creating a Pie Chart Part 1 Exploring Chart Types and Subtypes o A pie chart is a chart in the shape of a circle divided into slices like a pie Each slice represents a single value from a data series Larger data values are represented with bigger pie slices The relative sizes of the slices let you visually compare the data values and see how much each contributes to the whole o Pie charts are most effective with six or fewer slices and when each slice is large enough to view easily Carey Pinard Shaffer Shellman Vodnik New Perspectives Collection Microsoft Office 365 Office 2019 1st Edition 2020 Cengage All Rights Reserved May not be scanned copied or duplicated or posted to a publicly accessible website in whole or in part Creating a Pie Chart Part 2 The data displayed in a chart come from a data source which includes one or more data series and a set of category values o The data series is the actual values that are plotted on the chart The Charts category in the Quick Analysis tool displays chart types that are appropriate for the