Data Display

08:00 Class Recording | 10:10 Class Recording

note

Download and use this Gradesheet as a checklist before submitting full project to SAKAI by April 26 at 11:55 p.m. This sheet covers all sessions and is repeated at the top of each Data session: 04/02, 04/09, 04/16, & 04/23

Link to Very Specific Steps for Required Tasks

Class website link: Value to Categories

Below is a general overview of what we are doing.

18-Chart 1 Data: Compare Value to Categories#

Learning objectives: Duplicate Worksheet, Select/Sort Data, Create Chart, remove unneeded data, format chart#

There are a lot of steps in creating a chart in Excel, but once you get the idea of how and why, it only takes a short time to make a chart and is very, very easy.

Prepare the Data for the Chart 1-5.#

Numbers of Persons Serving in the Korean War is fine for the chart title on the resultant chart, but it will not fit on the worksheet tab name at the bottom of the workspace, so name it Korean War Chart on the tab.

  1. Copy a sheet rename it by right clicking on the Worksheet and choose copy.
  2. Move the new sheet to the end of the worksheets.
  3. Identify the label data.
  4. Identify the numerical data.
  5. After the data is identified, Sort or Filter ALL the data. (This is a preview of the data tools session for next week.) You must make sure you sort all the related data.

Select the Data for the Chart, Create the Chart, Move the Chart to a New Worksheet#

Select the cells you need. You will have to limit what you select so that only the data you need is shown in the chart. There are multiple ways to limit what you select.

The most powerful way to do this is counter intuitive: you select more than you need and then you turn off the data columns you don't want to show using chart tools via a right click.

  1. Use the Chart wizard to easily make a chart.
  2. Right click on a blank part of the chart to get a popup window to move the chart to a new sheet.
  3. Name the sheet as directed. Name the tab with the Shorter Name.
  4. Format the chart to personalize the colors, type etc.
Link to Very Specific Steps for Required Tasks

Value Percentages to Categories

Below is a general overview of what we are doing.

19-Chart 2 Data: Compare Value Percentage to Categories#

We will repeat all of the same steps we did in Chart One, but we will have two columns of data instead of one, so we will have to create different type of chart, a 100% Stacked Chart. we don't have to do a sort or a filter.

After we get the chart on a new sheet, we will format it and include a free-floating object.

Edit this page