meets Tuesday and Thursday from 0800-0915
office hours in Manning 112
Class Schedule
10 Jan | intro
15 Jan | clients
17 Jan | servers
22 Jan | networks
24 Jan | basics lab
29 Jan | structural layer
31 Jan | presentational layer
05 Feb | working with layers
07 Feb | behavior layer |
12 Feb | images & design
14 Feb | website lab
19 Feb | document markup
21 Feb | graphics
26 Feb | document markup lab
28 Feb | spreadsheets
05 Mar | formulas & functions
07 Mar |
thoughts about data display |
creating graphical data displays |
next session
19 Mar | database tools
21 Mar | spreadsheets lab
26 Mar | relational databases
28 Mar | tables
02 Apr | relationships
04 Apr | input & output
09 Apr | SQL
11 Apr | complex queries
16 Apr | databases lab
18 Apr | presentation design
23 Apr | presentation delivery
25 Apr | presentation lab
30 Apr | 0800-1100 | final in class presentation
This work
is licensed under a
Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Unported License.
home & schedule | class blog | syllabus | contact | grades
Spreadsheet data can be converted into many different ways of displaying data in charts.
But one needs to know what type of display is best suited for the underlying data.
Charts are a useful way to illustrate data shown in worksheets. Excel has several different types of charts to select from depending on the sort of information you are using and the effect you wish to convey in the graphic.
Column charts compare values across categories.
The same is true in Excel for Mac
bar charts are essentially the same thing, but oriented on the horizontal axis. Excel asserts they are the best chart type for comparing multiple values.
The same is true in Excel for Mac
Line charts compare continuous data over time against a common scale and are ideal for showing trends.
The same is true in Excel for Mac
But column charts do the same and in a more revealing fashion. Use a pie chart to show the relationship or proportion or parts to a whole, only when you want your chart to be metaphoric.
To quote Edward Tufte in The Visual Display of Quantitative Information , p. 178
... the only worse design than a pie chart is several of them ...
Given their low data-density and failure to order numbers along a visual dimension,
pie charts should never be used.
Area charts emphasize differences between several sets of data over a period of time.
... compare pairs of values, depicting them as sets of X and Y coordinates.
Start a chart by selecting the data (the source data) you want to chart. When doing so, keep the following points in mind:
One can create the chart on a new worksheet or within the current worksheet, depending on the data is to be displayed.
Change colored data series to patterns and shades of gray if you plan to use the chart in a print document.
Select the data array to be charted
Select the Insert ribbon to see your chart options.
The same is true in Excel for Mac
The tool will place the selected chart type on the same worksheet. You may wish to change this by moving the chart location to its own sheet.
To work on making the chart look and display as you wish it to, right click to reveal the chart editing options.
You have many formatting options, depending on the part of the chart that you select. Chart areas include:
The same is true in Excel for Mac
The same is true in Excel for Mac
You can also do more specific editing by right clicking and selecting the data to edit.
The same is true in Excel for Mac
When you put your cursor over an area of the chart, a tooltip appears. The tooltips provides chart information. Each of these areas can be edited/formatted. If you put the cursor over data point in chart, the tooltip will tell you the value of the data point.
You can add arrows, free-floating text, etc., using the drawing toolbar, but make sure the chart is selected before you add the arrow, for example, or it won't be put on the chart.
If you want to plot two values on the same grid, you can choose to have two differing axes if you use two differing data types.
You will need to change the series to a different chart type.
And then work to format two axes to depict two data sets on the same chart ...
... which will allow you to have two separate scales on a single grid.
You can make your own charts using the tools available. Jon Peltier offers a suggestion or you can follow Microsoft's advice.