1. Home
  2. Computing & Technology
  3. Spreadsheets

A Guide to Creating and Formatting Excel Charts

Charts are visual representations of your data, and, as the old adage states, “A picture is worth a thousand words”. Add a chart to your worksheet and save yourself from having to use those thousand words to explain your worksheet data. Tips, information, and step by step tutorials cover creating and formatting charts in Excel so that they clearly show what your spreadsheet data is about.
Excel Column Chart / Bar Graph Tutorials
These tutorials cover creating a column chart (also known as a bar graph) in Excel. Each tutorial includes a step by step example of creating a column chart in Excel 2007 or Excel 2003.
Excel Pie Chart Tutorials
Free tutorials on how to create and format a pie chart in Excel 2007 and Excel 2003. Each tutorial includes a step by step example of how to create and format a pie chart in Excel.
Excel 2007 Pie Chart
This free tutorial covers creating a pie chart in Microsoft Excel 2007. The tutorial includes a step by step example of creating a pie chart in the latest version of Excel.
Exploding a Pie Chart in Excel
This article covers how to explode out a single slice of a pie chart in Excel. Exploding out a single slice of the chart is a way to emphasis to the data represented by that slice.
Excel 2007 Column Chart
This tutorial covers creating a column chart in Microsoft Excel 2007. This tutorial includes a step by step example of creating a column chart in the latest version of Excel.
Excel 2007 Line Graph Tutorial
This tutorial covers creating a line graph in Microsoft Excel 2007. The tutorial includes a step by step example of creating a line graph in the latest version of Excel.
Excel 2007 Hi-Lo-Close Stock Market Chart
This tutorial covers creating a Hi-Lo-Close stock market chart in Microsoft Excel 2007. The tutorial includes a step by step example of creating a Hi-Lo-Close stock market chart in the latest version of Excel.
Create a Pictograph in Excel 2007
This step by step tutorial shows you how to create a pictograph in Excel 2007.
What is the Chart Wizard?
The Chart Wizard in Excel was designed to make the process of creating charts or graphs a very simple procedure. Make choices pertaining to your particular data in four different screens of the Chart Wizard, and your chart is created for you.
Step by Step Excel Chart Tutorial
This tutorial covers all the steps necessary for creating a chart using the Chart Wizard in Microsoft Excel. The tutorial begins by discussing the best practices for entering the chart data and then walks you through each of the four screens of the Chart Wizard.
Data for Step by Step Chart Wizard Example
Sample data to accompany the step by step tutorial on using the Chart Wizard in Excel. Use this sample data to follow the steps in the Chart Wizard tutorial.
Excel 2003 Charts
These tutorials cover such topics as how to create custom charts and how to change the default chart type in Excel 2003.
Excel 2003 Line Graph Tutorial
This tutorial covers creating a line graph in Microsoft Excel 2003. The tutorial includes a step by step example of creating a line graph in Excel using the Chart Wizard.
Excel 2003 Pie Chart Tutorial
This tutorial covers creating a pie chart in Microsoft Excel 2003. The tutorial includes a step by step example of creating a pie chart in Excel using the Chart Wizard.
Create a Bar Graph in Excel 2003
This tutorial covers creating a bar graph in Microsoft Excel 2003. The tutorial includes a step by step example showing how to create a bar graph using the Chart Wizard.
Formatting a Bar Graph
This article covers a number of formatting options for bar graphs in Excel.
Create a Pictograph in Excel 2003
This tutorial covers creating a pictograph in Microsoft Excel 2003. The tutorial includes a step by step example of creating a pictograph using the Chart Wizard.
Creating a Custom Excel Chart
If you have created a chart in Excel, complete with custom formatting, that you would like to use again with other charts save it as a custom chart type. Step by step instructions on creating a custom chart type in Excel.
How Do You Use Excel's Flow Chart Template?
Among the templates offered for free by Microsoft is one for creating simple flowcharts in Excel. The template works in all versions from Excel 97 on. A flowchart is a graphical representation of a process. This tip walks through how to download and use the flowchart template from Microsoft.
Changing Excel's Default Chart Type
If you don't like the default Excel chart type you can change it. This article shows you how to change the default chart type in Excel.
Microsoft Excel Charting FAQs
The FAQs on this site covers the steps necessary for creating charts in Excel. Whether you want information on how to properly layout the chart's data or you are looking for help on some of the more common errors and problems encountered when creating a chart, this site has information to help you.
What is a Custom Chart Type ?
Have you ever looked at the Custom Tab in Excel’s Chart Wizard and wondered when you might have a need to use it. Then there are the “User defined Custom Types” - when might you need those? Well this article gives you some insight into how to make the best use of the custom chart options available in Excel’s Chart Wizard.
Explore Spreadsheets
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Charts and Graphs

©2009 About.com, a part of The New York Times Company.

All rights reserved.