Microsoft Excel Charts Objectives l Using the Excel

Microsoft Excel Charts Objectives: l Using the Excel chart features l Selecting an Appropriate chart type l Creating a Chart l Editing a Chart CS&E 1111 Excharts

Charts l Why are charts useful? l l l Visual presentation of differences, similarities, general trends in data Easier to view and interpret at a glance Chart layout - terminology Types of charts Deciding which type of chart is appropriate for the problem at hand CS&E 1111 Excharts

Chart Layout & Termonology Chart Title Hotel Guests at The Bates Hotel Plot Area 1200 1000 Legend Dollars 800 General 600 Business Convention 400 200 Y Axis 0 Jan X Axis Feb Mar Apr May Jun Month Category-Axis Title CS&E 1111 Excharts

Selecting an Appropriate Chart Type Not all types of charts are appropriate for all data presentation needs • Line/Area Charts show changes or trends • Scatter Charts (XY) show a functional relationship • Bar/Column Charts show discreet values • Pie Charts show parts of a whole CS&E 1111 Excharts

A line chart shows a trend with each point plotted at equal intervals Notice how the distance on the x axis from 8 -9 am is the same as from 9 -11 am CS&E 1111 Excharts

An Scatter (XY) chart plots two sets of data at scaled intervals showing a functional relationship Notice how the data points are not distributed evenly but along a scaled x axis of interest rate CS&E 1111 Excharts

Bar/Column Charts show and compare discrete objects CS&E 1111 Excharts

Pie Charts display parts that make up a whole CS&E 1111 Excharts

Creating a Chart - Walkthrough: l Select data range l l continuous and contiguous data Click on Insert Ribbon and choose chart type Select chart headings, axis, labels etc from Layout Ribbon Modify chart formatting from the Format Ribbon CS&E 1111 Excharts

Editing a Chart: Walkthrough Double click on the chart to select it - use context sensitive ribbons to select features Design Ribbon Layout Ribbon Format Ribbon CS&E 1111 Excharts