SILS iSchool

week of 22 October 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. 13 Aug intro and clients | lecture | labs
  2. 20 Aug servers and command line | lecture | labs
  3. 27 Aug networks and protocols | lecture | labs
Web Development | sessions 04-07

  1. 03 Sep structural layer | lecture | labs
  2. 10 Sep presentational layer | lecture | labs
  3. 17 Sep using a structure | lecture | labs
  4. 24 Sep behavioral layer | lecture | labs
Dealing with Markup | sessions 08-09
  1. 01 Oct control objects and display | lecture | labs
  2. 08 Oct tools that read markup | lecture | labs
Working with Data | sessions 10-13
  1. 15 Oct formulas, functions, vectors | lecture | labs
  2. 22 Oct data display | lecture | labs
  3. 29 Oct manipulate data sets | lecture | labs
  4. 05 Nov relational data bases | lecture | labs
Presentation | session 14
  1. 12 Nov 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

Still using your downloaded workbook ...

prepare a worksheet to use to select the data

  1. Copy the 04-Hide Democratic Districts worksheet, place it in order near the end of the sequence of worksheets, and rename it 19-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 19-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.
  8. Insert the Compensation vs Medical Costs worksheet right after the 19-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 22 October labs | thinking about what kind of charts | compare value to categories | compare value percentages to categories