You can create a chart to show the changes in your data over time, or how the parts of your data fit together as a whole. You can rearrange your data, even after you have charted it, or added additional data. With Microsoft Excel and ChartWizard, you can easily turn your data into dynamic graphic presentations. Pie charts show the relationship of parts to a whole. Bar charts show comparison between items or comparison over time.
Line charts are often best for showing the amount of change in values over time.
As you use different types of graphic presentations you will get to know which chart is best for your data. Since it is so easy you may want to experiment with several types of charts to see which chart does the best job of clarifying your point. To create a chart on a worksheet, you will select the data that you want to use in the chart, and then click the Chart Wizard button on the Tool bar. The following exercises will take you step by step though the creation of several charts. Pie Charts and Bar Charts Example 1 .