Computer Applications- Excel

Charts

Chart Visual representation of data. Charts make it easy to view large amounts of data at a glance and show direct relationships between criteria ranges.

Pie Used to show percentage relationships, parts of a whole value (percentage of total).

Line Used to chart a value(s) over a period of time to make predictions (stock market, sales totals)

Bar/Column Used to show value(s) and relationships of multiple variables, possibly over time (sports statistics, grade/point distribution)

When creating a chart, be sure to:

  • Think about the purpose of your table. What are you trying to show?
  • Select relevant data. If your data range is not correct, you will end up with a chart that lacks validity.
  • Choose an appropriate chart. It should compliment the data and be easy to interpret at a glance.

Instructions: Create the 3 spreadsheets on the back of this note page, in the same worksheet, and make the following changes to create charts to match the data.

To create a chart:

  • Highlight appropriate range (include the column/row headings if possible
  • Click the Chart Wizard icon on the standard toolbar or choose Insert….Chart
  • Follow steps 1-4 in the dialog box to make changes, then save on a separate sheet.
  • Be sure to check your chart for spelling/grammatical errors

Chart 1--Stock Prices:

  • Create a line graph that shows the progress of all 4 stocks over all 4 quarters
  • Show values
  • Use Stock Prices as your title
  • Name the vertical axis Price, Name the horizontal axis Time
  • Display the legend at the bottom of the page

Chart 2—Pizza Sales:

  • Write a formula to calculate the total sales for the week and the percentage of total.
  • Create a pie chart that shows the percentage of sales for the 4 types of pizza for the week.
  • Choose the exploded pie chart with 3-D visual effects
  • Show labels and percentages
  • Use Pizza Percentages as your title

Chart 3—Sixers Stats:

  • Create a column chart that shows the points scored by each player in all four games
  • Choose a clustered column chart
  • Use Sixers Road Trip as your title
  • Name the vertical axis Points, Name the horizontal axis Game
  • Display the legend at the top of the page

**Please make any formatting changes that you feel would improve the visual effect of the chart.

Mr. AlbrechtComputer Applications-Excel01-02