Excel: Charts - PowerPoint PPT Presentation

Loading...

PPT – Excel: Charts PowerPoint presentation | free to view - id: 90917-MzEwZ



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Excel: Charts

Description:

Why Chart Stuff? Charts and graphs convey concepts more clearly than columns ... create separate and embedded charts. move, resize, enhance and format charts ... – PowerPoint PPT presentation

Number of Views:68
Avg rating:3.0/5.0
Slides: 24
Provided by: Tur2
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: 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
About PowerShow.com