Excel Lecture 2

1
Excel Lecture 2
2
Create column and pie charts in Excel

• Charts, or graphs, provide visual representations
  of the workbook data.
• A chart may be embedded in an existing worksheet,
  or can be created on a separate chart sheet, with
  its own tab in the workbook.
• You can use Excels Chart Wizard to quickly and
  easily create charts.
• The Chart Wizard is a series of dialog boxes that
  prompt you for information about the chart you
  want to generate

3
Create a chart usingthe Chart Wizard

• To create a chart with the Chart Wizard
• Select the data you want to chart, which will be
  your data source
• Click the Chart Wizard button on the standard
  toolbar
• In the first step of the chart wizard, select the
  chart type and sub-type
• In the second step of the Chart Wizard, make any
  additions or modifications to the chart's data
  source
• In the third step, make any modifications to the
  chart's appearance
• In the fourth and final step, specify the
  location for the chart, then click the OK button

4
Chart Wizard dialog box 1
5
Choosing a data series

• You can alter the data source during step 2 of
  the Chart Wizard and also choose whether to
  organize the data source by rows or by columns.
• The data source is organized into a collection of
  data series.
• A data series consists of data values, which are
  plotted on the chart's vertical, or Y-axis
• The data series category values, or X values,
  are on the horizontal axis, called the X-axis

6
Chart Wizard dialog box 2
7
Chart Wizard dialog box 3
8
Chart Wizard dialog box 4
9
Format chart elements

• To format an individual chart element, select the
  element by clicking it and then format its
  appearance using the same tools on the Formatting
  toolbar you used to format worksheet cells.
• You can also double-click the chart element to
  open a dialog box containing formatting options,
  or right-click the element and then select the
  Format command from the shortcut menu to open the
  dialog box.
• There are three basic types of text in an Excel
  chart
• Label text
• Attached text
• Unattached text

10
Excel chart text types

• Label text includes category names, tick mark
  labels, and legend text, which is linked to or
  derived from cells in the worksheet.
• Attached text is not linked to any cells in the
  worksheet examples include the chart title and
  the axes titles.
• Unattached text is any additional text that you
  want to include in the chart.

11
Format colors and patterns

• To work with colors and fills, double-click an
  element and the Format Data Series dialog box
  opens.
• You can use options provided on the Patterns tab
  to change both the border style and the interior
  of a data marker.
• You can also edit an axis scale by
  double-clicking any value on an axis to open the
  Format Axis dialog box.
• In the Format Data Series dialog box, the Pattern
  tab includes a Fill Effects button that provides
  a full range of options to create sophisticated
  colors and patterns, such as gradient, texture or
  even a picture.

12
Exercise
13
Overview

• Obtain the required spreadsheet vega1, from the
  INFO102 page.
• Save the file vega1 (as vega2) in the directory
  you created on your H drive (INFO102_Excel).
• Do sessions 4.1 and 4.2 (starting on page EX146).
  Ignore steps 1 and 3 on p. EX146 (but do step 2
  add your name and current date.
• Start the sessions today, complete prior to March
  2.
• Contact me if you have any issues.