Microsoft Office Tutorials and References
In Depth Information
Appendix: Generating Charts in Excel 2003 and Mac Excel 2011
APPENDIX: GENERATING CHARTS IN EXCEL 2003 AND MAC EXCEL 2011
Creating a Chart Using the Wizard Using the Chart Wizard (or alternatively the Insert
Chart) you may create a variety of charts. We start with simple charts.
The easiest way to create a chart is by arranging your data in the way that Excel
expects it; namely, try to position the data or names you want on the X-axis (the
horizontal axis) on the leftmost column of the chart reference data. You may arrange
it in different ways
but you will have to go through additional steps to create
the chart you desire.
Using the same data from the previous example (Figure 6.23), create a column
chart using the first and second columns data only. Select the first two columns and
click on the Chart Wizard. See Figure 6.28. The data is on the Simple Chart sheet of
the Excel file Chapter 6.
Select the very first chart type that pops up and proceed by clicking the Next
button on the menu. On the left part of Figure 6.29 appears the menu that lets you
change the data on the chart.
When you click the Next button in the chart window, you get to specify many of
the features of the chart. If you ignore or forget any of the steps, you will still be able
to access these formatting options when the chart is already completed.
The window under the Titles tab allows you to enter the labels for the chart
header as well as the names for the X- and Y-axes. See Figure 6.30. The Axes and
Gridlines menus allow you to specify their attributes.
In Figure 6.31 you see the other options available from the Chart Wizard tabs.
The legend tab allows you to specify whether you want a legend and if so, where you
would like to position it on the chart. The default position is on the right.
FIGURE 6.28 Chart Wizard