 |
You must select both a chart type (for example, bar) and a subtype (for example, clustered bar). The Chart Wizard allows you to select and preview the type of graphic that you want to create.
 |
|
By selecting Excel's Press and Hold to View Sample button, you can see how the graphic you selected will display your data.
|
|
Each type of graphic emphasizes different aspects of your data. Choose a graphic that is appropriate
for your audience and purpose. The following table lists common charts and graphs and their uses.
| If your purpose is to . . . | Use a . . . |
| Compare the relative values of two or more items | Column or bar graph |
| Show changes over time or demonstrate a trend | Line graph |
| Illustrate the relative sizes of components to one another and to the whole | Pie chart |
| Illustrate how activities occur over time | Gantt chart |
|
Note: A Gantt chart is not a standard chart type in Excel. There are, however, several ways to create a
Gantt chart. For creating complicated Gantt charts, you should use project-management software, such as
Microsoft Project. For less complicated Gantt charts, visit
Microsoft Office Online,
which includes a brief tutorial on how to create a Gantt chart in Excel by modifying a stacked bar chart.
You can also quickly create simple Gantt charts in Word using the table feature. To learn how, click here.
|
|
