Excel Charts

1
Excel Charts

• Comp 25

2
How worksheet data appears in the chart

• Worksheet rows become chart columns.
• Row titles become the chart legend text
• Column titles become the category names at the
  bottom of the chart.

3
Meet the Wizard

• Suppose you're looking at a worksheet that shows
  how many cases of Sir Rodney's Marmalade were
  sold by each of three salespeople in each of
  three months. How would you create a chart to
  show how the salespeople compare against each
  other, every month?
• To begin, you would select the data that you want
  to chart, as well as the column and row labels.
• Then you would click the Chart Wizard button on
  the toolbar to open the Chart Wizard.
• When the wizard opens, the Column chart type is
  selected. You could easily select another chart
  type, but in this case you'd accept the Column
  type, which is commonly used to compare items,
  and will get your point across.
• Next you would click the Finish button at the
  bottom of the wizard. For a quick chart, that's
  all you do.

4
Update and place charts

• The wizard placed this chart on the same
  worksheet as the data. You can move the chart on
  the worksheet by dragging it elsewhere.
• The wizard placed this chart as an object on the
  worksheet, along with the data, as shown in the
  picture. A chart can also be placed on a separate
  sheet in a workbook, something you'll see how to
  do in the next lesson.

5
What to Chart

• Data Range tab
• On this tab you could change your chart
  structure.
• You could choose which comparison to make by
  selecting either Rows or Columns in the Series in
  option. The option has that name because the
  worksheet values used in the chart are called
  data series. You choose whether to compare and
  group the series in rows or columns.
• Series tab
• On this tab you can delete or add a data series
  for the chart. For example, you might decide to
  chart only two of the salespeople instead of all
  three that you selected on the worksheet. The tab
  lets you change without going back to the
  worksheet, and it previews your changes.

6
Chart Options

• It's a good idea to add descriptive titles to
  your chart, so that readers don't have to guess
  what the chart's about. The Titles tab in Step 3
  of the wizard has boxes for three titles for this
  chart one for the chart, at the top, and one for
  each of the chart axes, vertical and horizontal.
  After the titles have been entered, they appear
  in the preview on this tab.
• You can add a title for the chart by typing in
  the Chart title box. For example Sir Rodney's
  Marmalade.
• Next is a title box for the Category (X) axis.
  This is Excel's term for the categories at the
  bottom of the chart (January and so on). You
  could call this axis First Quarter Sales.
• Next is a title box for the Value (Y) axis. In
  this chart it's the scale of numbers that show
  how many cases the salespeople sold. You could
  call this axis Cases Sold.

7
Even more tabs and options
8
PRACTICE! 4, 5, 6, 7