Creating Graphs in Excel
Scenario: You have been asked to make a presentation to the Director of Instructional Technology about the number of elementary and secondary schools that have school web sites. You wish to represent your findings in the form of a bar graph and insert this graph into your report written in Microsoft Word.
Step 1: Enter your data into Microsoft Excel.
Step 2: Highlight all of the data you wish to graph.
In this case, highlight from Cell A3 to C10.
Step 3: Click the Chart Wizard icon.
Step 4: In the box that appears, you can select your chart type.
In this case, choose the column graph with a 3-D visual effect.
Step 5: Click Next twice.
Step 6: On the title tab, add a title to your graph.
Title your graph: Technology Challenge.
Step 7: Name your axes.
In the Value (Z) axis, type Number of Web Sites.
Note: The Z-axis title is available, but not the Y-axis because the Y-axis extends back into the 3-Dimensional chart.
