word-excel-access-help.com logo
Excel Charts
Home
Word 2007
Excel 2007
Access 2007
Word xp
Excel xp
Access xp

Excel Charts
Additional Resources






Excel Charts

Excel Charts | Microsoft Excel XP

Microsoft Excel XP logo
Learn which Excel charts would be best to use for your data. See all the different charts that you can use.

When you show your data to someone, wouldn't it be great to put that data into a visual form? Excel XP helps you convert data into chart form so that your data is more than an abstract jumble of text and numbers.

Of course, you can create many different types of charts, including the standard favorites such as bar, pie, line, and scatter charts.

You can also choose from variants such as column and area charts, or explore chart types such as bubble, cylinder, cone, and pyramid.

Excel Office Helper What's on this page...
Types of Charts
Chart Elements


See also...
Excel Charting with the Chart Wizard
Modify Chart Elements

Types of Charts

There is a wide variety of chart types that you can choose from, but choosing the right type of chart can seem like a very daunting task.

Here is a list of charts that makes the most sense in using to display your data graphically.

For data with multiple columns and rows use:

2D Column Chart  3D Column Chart
Compares values across categories  
Excel Charts: 2D Column Chart Excel Charts: 3D Column Chart
   
You can also use the Cylinder, Cone or Pyramid chart types. These are the same as a Column Chart only in the shape of a cylinder, cone or pyramid. They are also in 2D and 3D.
   
2D Bar Chart 3D Bar Chart
Compares values across categories  
Excel Charts: 2D Bar Chart Excel Charts: 3D Bar Chart
   
2D Line Chart  
Line with markers displayed at each data value  
Excel Charts: 2D Line Chart  


For data with multiple columns and a single row (or vice versa) use:

2D Pie Chart 3D Pie Chart
Displays the contribution of each value to a total
Excel Charts: 2D Pie Chart Excel Charts: 3D Pie Chart

Chart Elements

The best way to understand your chart is to understand the chart elements. This way you know exactly what to change in the chart options.

The best way to see what each part of the chart is, is to place your mouse pointer over an element and hold it still. A tooltip pops-up and gives the name description of the specific element that you are pointing at.

 
See also..   Charting with the Chart Wizard  |  Modify Chart Elements
 
Back to Top
 
Return to Excel XP from Excel Charts
 
Excel XP Topics
- Tips
- Excel Screen Layout
- Navigational Techniques
- Working with Workbooks
- Templates
- Working with Worksheets
- Moving Around
- Move Worksheets
- Copy Worksheets
- Insert & Delete Cells
- Insert & Delete Rows
- Insert & Delete Columns
- Resize Row
- Resize Column
- Editing Data
- Content Color
- Cell Color
- Number Formats
- Fonts
- Alignment
- Text Direction
- Indent Contents
- Merge Cells
- Copy
- Move
- Undo & Redo
- Using Zoom
- Freeze & Unfreeze Titles
- Split Worksheet
- Spreadsheet Data
- AutoFill
- AutoComplete
- Comment
- Find
- Replace
- Spellcheck
- Formulas
- Functions
- Print
- Password
- Sorting
- AutoFilter
- Advanced Filter
- Macros
- Charts
- Charting
- Charting Elements
- Gantt Chart
- PivotTable
- PivotTable Calculations
- PivotTable Layout
- PivotTable Format
- PDF to Excel
- PDF-to-Excel Converter
- Excel to PDF Converter