Excel: Charts

1
Excel Charts Importing

• David Turton
• Conestoga College
• Institute of Technology Advanced Learning
• http//www.conestogac.on.ca/dturton
• Doon 1B43 x3610

2
Why Chart Stuff?

• Charts and graphs convey concepts more clearly
  than columns of tabular data
• expose trends relationships
• objectives
• create separate and embedded charts
• move, resize, enhance and format charts
• examine different charts
• Import data into Excel

3
Chart samples
4
Initiating a Chart

• Select the range of data to be plotted, including
  x y values
• Press F11 (default graph, separate sheet)
• or click graph icon
• or right-click worksheet tab choose insert
• x data assumed to be longest side of range
• (left-most or top-most side)
• can modify the assumptions later

5
Using chart iconStep 1

• chart type
• line, bar, column, pie
• chart style
• 3D, stack, exploded

6
Using chart iconStep 2

• Data ranges
• column vs row
• which is x axis?

7
Using chart iconStep 2b - Series tab

• Opportunity to
• add or remove a range
• provide or point out a name for each range
• pick a non-standard x-axis

8
Using chart iconStep 3

• Layout options
• chart/axis titles
• gridlines
• legend position
• show data labels (values)
• show raw data
• nice x-axis feature
• fixed interval/timescale

9
Using chart iconStep 4

• Positioning
• embeded with data (overlay, same sheet)
• or a separate sheet

10
Net Result - your chart
11
Selecting non-adjoining areas

• Either select them in the first place
• select 1st range, release mouse button
• Ctrlselect 2nd range, release etc.
• or select all delete unwanted ones later
• step 2 - add/remove ranges w/ Series tab
• or click on a ranges chart line press Delete
• or select a new range drag onto chart

12
Changing Charts

• Select chart chart icon
• go through 4 steps
• right-click chart area
• alt. route to 4 steps
• right-click on a data line
• change order, characteristics, colour
• nice trend line (see next page)

13
Trend/Regression Linesimple data
14
Trend/Regression Linemore complex data
15
Use drawing toolbar to annotate charts
16
Pie Chartsselect titles and a data range
17
Pie Options2D/3D, amounts/titles/percent,
explode or click drag a slice
18
Maps (FYI not installed here)shading shows
magnitude by geographic location

• select range
• provinces, states, or countries as x-axis
• click on globe icon (may need to add it)
• mark where youd like it.

19
Options different countries, bullet/scatter
chart denoting volume, etc.
20
Importing Text Data
Open non-Excel files same way, just specify to
look for alternate file types
21
Specifying Delimiters1st screen delimited or
fixed-width2nd screen identify delimiters
Note watch for multiple spaces
22
Note special formatting so dates aren't
meaningless text
23
Finish - spreadsheet loaded
Problem column not wide enough for data