SILS iSchool

week of  02 April 2020 

thinking about what kind of charts | compare value to categories | compare value percentages to categories



Value Added | daily

Class Schedule

Basics | sessions 01-03
  1. 09 Jan intro and clients | lecture | labs
  2. 16 Jan servers and command line | lecture | labs
  3. 23 Jan networks and protocols | lecture | labs
Web Development | sessions 04-07

  1. 30 Jan structural layer | lecture | labs
  2. 06 Feb presentational layer | lecture | labs
  3. 13 Feb using a structure | lecture | labs
  4. 20 Feb behavioral layer | lecture | labs
Document Markup | sessions 08-09
  1. 27 Feb control objects and display | lecture | labs
  2. 05 Mar tools that read markup | lecture | labs
Working with Data | sessions 10-13
  1.  26 Mar  formulas, functions, vectors | lecture | labs
  2.  02 Apr  data display | lecture | labs
  3.  09 Apr  manipulate data sets | lecture | labs
  4.  16 Apr  relational data bases | lecture | labs
Presentation | session 14
  1.  23 Apr  designing and delivering a presentation | lecture | labs


Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.

home & schedule | syllabus | contact | grades
Create a chart that compares multiple data sets by region

prepare a worksheet to use to select the data

  1. Copy the 04-Hide Democratic Districts worksheet and rename it 17-Chart 2 Data.
  2. We want to compare the Compensation & Pension to the Medical Care costs for each county. 

back to top

Generate the chart

  1. Use the data from the 17-Chart 2 Data worksheet, but restrict the chart data to only these two sets of numeric values.
  2. Use a chart that compares values to categories.
    Use any appropriate chart style that pleases you, but again here, do not settle for the defaults.
  3. This will be a 100% stacked chart of some type.
  4. You will be using raw numbers and having the chart tool convert the numbers to relative percentages. Do not create the percentages yourself.
  5. Customize the chart in some fashion.
  6. Create a chart that compares the percentage of each value contributes to a total across categories and place the chart on a separate worksheet.
    This means the chart stands alone on a worksheet and does not float above a grid of cells on a worksheet.
  7. Name the standalone worksheet Compensation vs Medical Costs, and insert it directly after the 17-Chart 2 Data worksheet.
  8. Insert the sheet right after the 17-Chart 2 Data worksheet.  

You may use the chart wizard, but do not use the defaults.

back to top

Demonstrate facility with the chart formatting tools

  1. Make it very clear in the formatting which values are which. Format your axes and axes labels so that the viewer is in no doubt about what is being depicted. If the data format is self-explanatory, you may not need a label for an axis.
  2. If you use a legend, be sure to have the legend pull its name from the appropriate cell in the worksheet.
  3. Put the legend at the bottom of the chart without overlapping the data.

back to top

Annotate the chart using a drawing object

  1. Annotate the chart by including a free-floating object to point out the county who has the highest percentage of Medical costs .

back to top

week of 02 April labs | thinking about what kind of charts | compare value to categories | compare value percentages to categories