You've seen how to create handy XY charts in the previous recipe and would like to learn what other chart types are available in Excel.
Excel has several built-in chart types to choose from. Excel's standard chart types are:
The Column type includes the sub-types Clustered Column, Stacked Column, 100% Stacked Column, Clustered Column 3-D, Stacked Column 3-D, 100% Stacked Column 3-D, and 3-D Column.
The Bar type includes the sub-types Clustered Bar, Stacked Bar, 100% Stacked Bar, Clustered Bar 3-D, Stacked Bar 3-D, and 100% Stacked Bar 3-D.
The Line type includes the sub-types Line, Stacked Line, 100% Stacked Line, Line with Markers, Stacked Line with Markers, 100% Stacked Line with Markers, and 3-D Line.
The Pie type includes the sub-types Pie, Pie 3-D, Pie of Pie, Exploded Pie, Exploded Pie 3-D, and Bar of Pie.
The XY type includes the sub-types Scatter, Scatter with smoothed lines, Scatter with smoothed lines and markers, Scatter with lines, and Scatter with lines and markers.
The Area type includes the sub-types Area, Stacked Area, 100% Stacked Area, Area 3-D, Stacked Area 3-D, and 100% Stacked Area 3-D.
The Doughnut type includes the sub-types Doughnut and Exploded Doughnut.
The Radar type includes the sub-types Radar, Radar with Markers, and Filled Radar.
The Surface type includes the sub-types 3-D Surface, Wireframe 3-D Surface, Contour, and Wireframe Contour.
The Bubble type includes the sub-types Bubble and Bubble 3-D.
The Stock type includes the sub-types High-Low-Close, Open-High-Low-Close, Volume-High-Low-Close, and Volume-Open-High-Low-Close.
The Cylinder type includes the sub-types Column, Stacked Column, 100% Stacked Column, Bar, Stacked Bar, 100% Stacked Bar, and 3-D Column.
The Cone type includes the sub-types Column, Stacked Column, 100% Stacked Column, Bar, Stacked Bar, 100% Stacked Bar, and 3-D Column.
The Pyramid type includes the sub-types Column, Stacked Column, 100% Stacked Column, Bar, Stacked Bar, 100% Stacked Bar, and 3-D Column.
In addition to these standard chart types, Excel has many other built-in, custom chart types to choose from. Moreover, you can combine many of the these chart types on a single chart to create your own custom chart type, which you can save in the Custom Types list for repeated use.
To different types of charts, follow the same procedure described in Recipe 4.1. Just select a different type of chart during step 1 of the Chart Wizard process. The Chart Type dialog box (step 1 of the Chart Wizard) shows you all of the available built-in chart types. You can select any type and view a preview of the resulting chart by pressing the preview button, as discussed earlier. The Custom Types tab of the Chart Type dialog box also allows you to select or add custom chart types. (See Recipe 4.12 for more information.)
See Recipe 4.8 to learn how to set different styles for each data series on a single chart.
Getting Acquainted with Visual Basic for Applications
Collecting and Cleaning Up Data
Time Series Analysis
Curve Fitting and Regression
Numerical Integration and Differentiation
Solving Ordinary Differential Equations
Solving Partial Differential Equations
Performing Optimization Analyses in Excel
Introduction to Financial Calculations