Excel 2007 Charts and Graphs

This tutorial explains Excel 2007 Charts and Graphs

Excel 2007 Charts are visual representations of data. Excel offers several different types of charts, suitable for many different types of data. A well-designed chart can present complex data in an easy to understand manner, suitable for any audience.

 

Creating a Chart in Excel 2007

Excel 2007 Charts are created using the Charts group of the Insert tab.

To create a chart,

  1. Highlight the data to be included in the chart.

    WorkingWithCharts_1

  2. Select the chart type from the Charts group of the Insert tab. A gallery opens for each type of chart. For the example below, we will use the 2-D Column chart.

    WorkingWithCharts_2

    The chart inserts in the worksheet.

    WorkingWithCharts_3

Changing the Chart Layout

To change the chart layout, click a different chart layout in the Chart Layouts group of the Chart Tools Design tab.

WorkingWithCharts_4

Changing the Data Orientation

To change the data orientation, click Switch Row/Column in the Data group of the Chart Tools Design tab.

WorkingWithCharts_5

The orientation will change.

WorkingWithCharts_6

Changing the Chart Type

To change the chart type,

  1. Click Change Chart Type in the Type group of the Chart Tools Design tab.
  2. Select the desired chart type.
  3. Click OK. The chart type changes.

    WorkingWithCharts_7

Understanding Chart Types

Chart Type Uses
Column Compares values acrocss categories.
Line Displays trends over time.
Pie Displays the contribution of each value to the total.
Bar Compares multiple values.
Area Displays differences between sets of data over time.
Scatter Also known as an XY chart. Compares pairs of values.
Other Stock - Used for stock-market related data.
Surface- Displays trends in values across two dimensions
Doughnut - Displays the contribution of each value to the total. Can contain multiple series.
Bubble - Compares sets (3) of values. Acts like a Scatter but with sets of 3 rather than 2.
Radar - Displays values relative to a center point.

Embedding a Chart or a Chart Sheet

Charts can be embedded in a worksheet, or exist on their own sheet. By default, Excel creates charts as embedded objects in the worksheet containing the chart data.

To change the chart so that it exists on its own sheet,

  1. Click the chart.
  2. Click Move Chart in the Location group of the Chart Tools Design tab.

    WorkingWithCharts_8

    The Move Chart screen opens.

    WorkingWithCharts_9

  3. Choose New Sheet to place the chart on its own sheet.
  4. Type a name for the chart’s sheet if desired.
  5. Click OK. The chart displays on its own sheet.

    WorkingWithCharts_10

Moving and Resizing an Embedded Chart

To move an embedded chart, click on the chart and drag it to the desired location.

To resize an embedded chart, click on one of the chart’s handles and drag to the desired size. Notice that your cursor changes when hovering over a handle.

WorkingWithCharts_11

  • Handles at the corners resize the chart proportionally.
  • Handles at the top and bottom resize the chart vertically or horizontally. This can distort the chart.

Adding a Chart Title

To add a chart title,

  1. Click the chart.
  2. Select a Chart Title style from the Chart Titles dropdown in the Labels group of the Chart Tools Layout tab.

    WorkingWithCharts_12

    The title is inserted.

    WorkingWithCharts_13

    NOTE: Depending on the chart and options selected, labels may automatically be added to the chart when it is inserted.

Adding Axis Titles

Axes are lines bordering the chart area. They act as a frame of reference for measurement.

Axis titles are helpful when working with column, line, scatter and other chart types. Axis titles cannot be used with doughnut and pie charts.

To add axis titles,

  1. Click the chart.
  2. Click the Axis Titles dropdown in the Labels group of the Chart Tools Layout tab.

    WorkingWithCharts_14

  3. Select the desired options from the Primary Horizontal Axis Title or Primary Vertical Axis Title groups.

    In the example below, I’ve added a Primary Vertical Axis Title – Rotated Title, and changed the text to read, Sales Totals.

    WorkingWithCharts_15

Changing the Location of a Chart Legend

The chart legend is used to identify the colors or patterns used in the chart.

To change the location of the chart legend,

  1. Click the chart.
  2. Click the Legend dropdown in the Labels group of the Chart Tools Layout tab.

    WorkingWithCharts_16

  3. Select the desired option from the Legend dropdown. The legend is displayed in the chart. In the example below, Show Legend at Top is used.

    WorkingWithCharts_17

Adding Data Labels

Data labels are labels that provide information about data points within the chart.

To add a data label,

  1. Click the chart.
  2. Click the Data Labels dropdown in the Labels group of the Chart Tools Layout tab.

    WorkingWithCharts_18

  3. Select the desired option from the Data Labels dropdown. The data labels are added to the chart. In the example below, I’ve added Outside End data labels.

    WorkingWithCharts_19

Adding a Data Table to a Chart

A data table is used to display the data being used in the chart. In the example below, the data table shows the values represented by each of the columns in the chart.

WorkingWithCharts_20

In more complex charts, data tables can be used to show the results of data substitution in one or more formulas represented in the chart.

To add a data table,

  1. Click the chart.
  2. Click the Data Tables dropdown in the Labels group of the Chart Tools Layout tab.

    WorkingWithCharts_21

  3. The selected data table is added to the chart. In the example above, Show Data Table with Legend Keys is used.

Changing the Chart Axes

Axes are lines bordering the chart area. They act as a frame of reference for measurement.

To change the chart axes,

  1. Click the chart.
  2. Click the Axes dropdown in the Axes group of the Chart Tools Layout tab.

    WorkingWithCharts_22

  3. Select the desired axes from the Primary Horizontal Axis and/or Primary Vertical Axes groups.

    WorkingWithCharts_23

Changing the Gridlines

Gridlines make charts easier to read.

To change the gridlines,

  1. Click the chart.
  2. Click the Gridlines dropdown in the Axes group of the Chart Tools Layout tab.

    WorkingWithCharts_24

    Select the desired gridline style from the Primary Horizontal Gridlines and/or Primary Vertical Gridlines groups.

    WorkingWithCharts_25

Formatting the Chart Elements

Individual chart elements can be formatted in many different ways.

In the example below, I’ll format the fill for the columns. To format the fill for the columns,

  1. Click the column to format.

    WorkingWithCharts_26

  2. Using the options available on the Chart Tools Format tab, format the column, or other element as desired. In the example below, I changed the column fill and outline to orange.

    WorkingWithCharts_27

Moving, Resizing, and Deleting Chart Elements

Moving

To move a chart element, click on the element and drag it to the desired position using the mouse.

Resizing

To resize a chart element,

  1. Click on the element over one of the handles.

    WorkingWithCharts_28

    Notice the cursor changes to a double headed arrow.

  2. Drag the handle, enlarging the element to the desired size.
    • Handles at the corners resize the object proportionally.
    • Handles on the top and bottom resize the object vertically or horizontally. This can distort the object.

Deleting

To delete a chart element, click the element and press Delete.

Deleting a Chart

To delete a chart, click the chart and press Delete.

Printing a Chart

Charts can be printed with or without worksheet data.

With Worksheet Data

To print a chart with worksheet data,

  1. Change the view to Page Layout by clicking Page Layout in the Workbook Views group of the View tab.

    WorkingWithCharts_29

  2. Use the tools available to resize the chart, drag it to a new position, adjust orientation, margins, etc., so that the chart and data print as desired.

    WorkingWithCharts_30

Without Worksheet Data

To print a chart without worksheet data,

  1. Click the chart.
  2. Click the Microsoft Office button.
  3. Click Print.
  4. Verify that Selected Chart is selected in the Print What section of the Print screen.

    WorkingWithCharts_31

  5. Click OK.

How to Link to This Page

It will appear on your page as: Excel 2007 Charts

 


Search for Tutorials
 

Excel 2007 Tutorials: Excel 2007

Excel 2007 Tutorials
Excel 2007 Charts
Excel 2007 Graphics
Excel 2007 Worksheets
Excel 2007 Worksheet Views
Excel 2007 Formulas
Excel 2007 Named Ranges
Excel 2007 Cell Comments

Excel Video Tutorials
Lesson 1: Excel Basics
Lesson 2: Editing a Worksheet
Lesson 3: Making Bar and Circle Graphs
Lesson 4: Making a Gantt Chart
Lesson 5: Excel Keyboard Shortcuts

More Excel Tutorials at GuidesandTutorials.net

All Other Guides and Tutorials

Guides and Tutorials Blog
Listing of the latest tutorials published on the GuidesandTutorials website.
GuidesandTutorials: Audacity Tutorial - Record and Edit Audio
This Audacity tutorial will show you how to use the basic tools and procedures in the open source audio editing program, Audacity. Not just screen shots, but free narrated multimedia tutorials - You'll learn to use Audacity for recording and editing audio files that can be used for podcasting, mixing music and vocals, creating sound tracks, and other audio projects.
Audacity Tips & Tricks
Audacity tips and tricks submitted by users
Digital Photography Guide
This Digital Photography Guide will provide you with the basic information you need to take professional quality photogrphs with your digital camera.
GuidesandTutorials: Dreamweaver Tutorial
Dreamweaver Tutorial - this series of free Dreamweaver tutorials is just what you need to get up and running with Dreamweaver to create interesting and compelling web sites
GuidesandTutorials: Microsoft Excel 2003 Tutorial
This Excel 2003 Tutorial will introduce you to the basics of using the Excel 2003 spreadsheet program. You'll learn to create a spreadsheet, basic Excel workbook skills, work with cells, enter and manipulate data, apply formulas, format data, create and work with charts, and manage Excel workbooks.
Podcasting Tutorial
This Podcasting tutorial includes a step by step guide that will show you how to record, publish and promote your podcast. Using inexpensive equipment and free software, you'll be publishing podcasts in no time.
PowerPoint Tutorial - Microsoft PowerPoint 2003
This PowerPoint tutorial is just what you need to learn how to use PowerPoint 2003 to create effective and engaging presentations.
The PowerPoint 2007 Window
This PowerPoint 2007 tutorial will show you the features and how to get around the PowerPoint Window.
GuidesandTutorials: Free PowerPoint Templates
Free PowerPoint templates that you can download and use today. This is a growing library of free resources for PowerPoint users.
LCD Projector Guide and Tutorial
This LCD Projector Guide will assist you in the use and purchase of a digital LCD projector or DLP projector. It will discuss the differences between LCD and DLP projectors, size and portability considerations, lamp types and brightness, resolution, image quality and other considerations in the use and purchase of a digital projector.
Word Tutorial: Microsoft Word 2003
This Word tutorial is just what you need to learn how to use Word 2003 to create professional looking documents.
Word 2007 Workspace
This Microsoft Word 2007 Workspace tutorial will acquaint you with the new tools and features in the Word 2007 Window. It's changed significantly from previus versions and even experienced users will find this helpful.
Work at Home Jobs
This Work at Home Jobs tutorial will provide information on ways that you can put your skills and knowledge to use in creating part or full time income while working from home.
Guides and Tutorials: Free Guides and Tutoials Site Map
Free guides and tutorials on podcasting, digital video and audio, Audacity, RSS, multimedia development, educational technology, technology integration, K12 Technology, PowerPoint.
Suggest a New Technology Tutorial
Free Technology Tutorials on software and technology applications including PowerPoint tutorials, Podcasting tutorials, Dreamweaver tutorials, Audacity, Non-Linear PowerPoint, Digital Photography, RSS tutorial, and everything educational technology.
Adobe Acrobat 9 Tutorial
This Adobe Acrobat 9 Tutorial will show you how to create PDFs from MS Office applications, from Multipe files, from web pages and from several other types of documents.
GuidesandTutorials: Free Tutorials
Free Tutorials, software, hardware, and technology applications including PowerPoint, Podcasting, Dreamweaver, Audacity,
Excel 2007 Tutorial | GuidesandTutorials: Free Tutorials
This free Excel 2007 Tutorial will show you how to use all of the begginer and intermediate features in Excel 2007

This site proudly build with Site Build It!

Powered By SiteBuildIt

 

Excel 2007 Ebook: The Ultimate Guide - $12.95

Excel 2007 Ebook

Get the Excel 2007 Ebook: The Ultimate Guide and receive all of the Excel 2007 tutorials in one handy reference guide. Purchase online easily with your credit card or PayPal and have the Ebook emailed to your email address (pdf format)

Price: $12.95. California residents pay 7.25% Sales tax. Delivered via email.

Excel Video Tutorials
1. Excel Basics
2. Editing a Worksheet
3. Making a Gantt Chart
5. Excel Keyboard Shortcuts

Excel 2007 Tutorials
Excel 2007 Charts
Excel 2007 Graphics
Excel 2007 Worksheets
Excel 2007 Worksheet Views
Excel 2007 Formulas
Excel 2007 Named Ranges
Excel 2007 Cell Comments

More Excel Tutorials at
GuidesandTutorials.net

[?] Subscribe To This Site

XML RSS
follow us in feedly
Add to My Yahoo!
Add to My MSN
Subscribe with Bloglines