Charts MOAC Lesson 6 Chart Visual representations of

  • Slides: 20
Download presentation
Charts MOAC Lesson 6

Charts MOAC Lesson 6

Chart �Visual representations of numerical data (John Wiley & Sons, Inc. , 2012) Cate.

Chart �Visual representations of numerical data (John Wiley & Sons, Inc. , 2012) Cate. . . Series 3 Cate. . . 15 10 5 0 Series 2 Series 1

Inserting Charts �Using the Chart icon in the placeholder �Simplest way to insert a

Inserting Charts �Using the Chart icon in the placeholder �Simplest way to insert a chart �Insert Ribbon > Illustrations Group > Chart

Inserting Charts �Once you insert a chart, Microsoft Excel is launched �If Excel is

Inserting Charts �Once you insert a chart, Microsoft Excel is launched �If Excel is not on your computer, Power. Point uses Microsoft Graph �Once data is entered into Excel, you do not have to save the Excel file, it automatically saves in click on the Edit Data icon on the Chart Tools Design Ribbon

Chart Tools Ribbons �Chart Tools Design – allows the user to edit data, change

Chart Tools Ribbons �Chart Tools Design – allows the user to edit data, change the chart type, change the chart layout, and apply a Quick Style �Chart Tools Format – allows you to format the chart colors, outline, etc.

Parts of a Chart �Data Series: consists of all the data points for a

Parts of a Chart �Data Series: consists of all the data points for a particular category (John Wiley & Sons, Inc. , 2012) �Example: On a bar chart, the bars that share a common color (John Wiley & Sons, Inc. , 2012)

Parts of a Chart �Data Marker: One individual column or point in a series

Parts of a Chart �Data Marker: One individual column or point in a series (John Wiley & Sons, Inc. , 2012) �Example: The second blue bar in the chart �Legend: provides a key to the information plotted on the chart (John Wiley & Sons, Inc. , 2012)

Data Series vs. Data Marker 6 Legend Data Marker 5 Data Series 4 Series

Data Series vs. Data Marker 6 Legend Data Marker 5 Data Series 4 Series 1 3 Series 2 2 Series 3 1 0 Category 1 Category 2 Category 3 Category 4

Parts of a Chart �Chart Area: The entire area inside the chart container that

Parts of a Chart �Chart Area: The entire area inside the chart container that holds background as well as plotted data (John Wiley & Sons, Inc. , 2012) �Includes the plot area and the legend

Parts of a Chart �Plot Area: The area in the chart container that shows

Parts of a Chart �Plot Area: The area in the chart container that shows the data series compared to the chart’s gridlines (John Wiley & Sons, Inc. , 2012) �Usually contains gridlines and elements such as columns (John Wiley & Sons, Inc. , 2012)

Chart Area vs. Plot Area – Textured Background Chart Area – Blue Background 6

Chart Area vs. Plot Area – Textured Background Chart Area – Blue Background 6 5 4 Series 1 3 Series 2 Series 3 2 1 0 Category 1 Category 2 Category 3 Category 4

Series 1 Series 3 at e C. . . at e. . . Series

Series 1 Series 3 at e C. . . at e. . . Series 2 C Chart Labels 6 4 2 0 � Allow the audience to see determine what the chart represents � Chart Title – The title that is usually centered over the entire chart � Axis Labels – text that identifies information about the values on an axis (John Wiley & Sons, Inc. , 2012) � Data Labels – Provide information about each data marker

Chart Labels �Numbers along the vertical and horizontal axis can be adjusted by adjusting

Chart Labels �Numbers along the vertical and horizontal axis can be adjusted by adjusting the axis scale

Vertical Axis Title/Label Chart Titles 5 4 3. 5 3 2. 5 2 1.

Vertical Axis Title/Label Chart Titles 5 4 3. 5 3 2. 5 2 1. 5 1 0. 5 0 Data Labels Chart Title 4. 4 4. 3 2. 4 Series 1 2. 5 2 2 Series 3 Category 1 Category 2 Horizontal Axis Title/Label

Chart Types �To change the type of chart inserted on a slide, go to

Chart Types �To change the type of chart inserted on a slide, go to Chart Tools Design > Type Group > Change Chart Type �Pie Chart: show the relationship of parts to a whole (John Wiley & Sons, Inc. , 2012) �Draws its data from a single column or row of data (John Wiley & Sons, Inc. , 2012) Sales 1 st Qtr 2 nd Qtr 3 rd Qtr

Series 1 Cate. . . Chart Types 6 4 2 0 Series 2 �Column

Series 1 Cate. . . Chart Types 6 4 2 0 Series 2 �Column Chart: good for comparing values side-by-side from multiple data series (John Wiley & Sons, Inc. , 2012) �Default chart type �Data is charted along the vertical axis (John Wiley & Sons, Inc. , 2012)

Chart Types �Line Chart: shows the amount of change over time and total value

Chart Types �Line Chart: shows the amount of change over time and total value across a trend 6 4 Series 1 0 Series 2 C at eg C or. . at. eg or. . . 2 Series 3

Formatting Charts � To move a chart, click on the border and drag it

Formatting Charts � To move a chart, click on the border and drag it to its new position � To resize a chart, click on the outside border and drag OR press and hold the Shift key, then click the outside border and drag so that the height and width maintain their ratio (aspect) � Individual elements (data markers, data labels, axis labels) can be hyperlinked to other files/websites �Click on element and go to Insert > Hyperlink

Formatting Charts �Quick Style – enables a user to quickly format a chart with

Formatting Charts �Quick Style – enables a user to quickly format a chart with different colors, effects, and background (John Wiley & Sons, Inc. , 2012)

Source John Wiley & Sons, Inc. (2012). Microsoft Official Academic Course Microsoft Power. Point

Source John Wiley & Sons, Inc. (2012). Microsoft Official Academic Course Microsoft Power. Point 2010, Exam 77 -883.