You are here:About>Computing & Technology>Spreadsheets> Charts and Graphs
About.comSpreadsheets

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 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.
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.
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.
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.
 All Topics | Email Article | | |
Advertising Info | News & Events | Work at About | SiteMap | Reprints | HelpOur Story | Be a Guide
User Agreement | Ethics Policy | Patent Info. | Privacy Policy©2008 About, Inc., A part of The New York Times Company. All rights reserved.