How to Make a Graph in Microsoft Excel 2007 for Windows
Open up Microsoft Excel 2007 on your computer., Enter the desired category data for the information you want to compare in the A column., Next you should type in the x-axis labels into row 1 that you want., Enter the values you want for the y-axis...
Step-by-Step Guide
-
Step 1: Open up Microsoft Excel 2007 on your computer.
Each category should be in a cell beginning with A2.
In the example below, I used Fuel, Clothing, and Entertainment costs. , Each label should be in a separate cell beginning with B1.
In the example below, I typed in the four months that were being tracked. , The data should correspond to the correct x-axis and category.
In my example I entered the amount of money spent for each item for each month rounded to the nearest dollar. ,, This will be the second tab from the left , For my data, I used a Bar graph because it’s good at showing different x-axis variables that represent different data.
Many graphs portray data differently.
I will have more information on this in my tips section.
The types of charts are listed in the middle of the tab menu such as Column, Line, Pie, Bar, etc.
A drop-down menu of Bar Chart designs will be shown after you click on one of them. , When you put your mouse over the chart option, you'll see a description of what the chart display is good for.
For example, select “2D Bar” in a clustered column for the type of chart.
The chart will appear on the spreadsheet using the data in a 2D form. , To add graph titles or axis titles simply click on the titles tab.
A drop-down menu will appear where you can choose the one you prefer. , by clicking on the text and editing it. , If copy and pasting doesn't work you can always try taking a screen shot of the image and inserting into the selected document. -
Step 2: Enter the desired category data for the information you want to compare in the A column.
-
Step 3: Next you should type in the x-axis labels into row 1 that you want.
-
Step 4: Enter the values you want for the y-axis data in the correct data cells.
-
Step 5: Highlight the data in the spreadsheet by clicking on the upper left hand corner of the data table
-
Step 6: then drag the mouse across the entire data range.
-
Step 7: Click on the “Insert” Tab in the menu at the top of the screen.
-
Step 8: Click on the type of chart that you want to use to represent your data.
-
Step 9: Select the type of chart that is best suited for the display you want.
-
Step 10: Click on your graph and and then click on the layout tab.
-
Step 11: Make changes to the chart as needed in the title
-
Step 12: legend
-
Step 13: After you are done formatting and editing the graph you can copy and paste it into other documents.
Detailed Guide
Each category should be in a cell beginning with A2.
In the example below, I used Fuel, Clothing, and Entertainment costs. , Each label should be in a separate cell beginning with B1.
In the example below, I typed in the four months that were being tracked. , The data should correspond to the correct x-axis and category.
In my example I entered the amount of money spent for each item for each month rounded to the nearest dollar. ,, This will be the second tab from the left , For my data, I used a Bar graph because it’s good at showing different x-axis variables that represent different data.
Many graphs portray data differently.
I will have more information on this in my tips section.
The types of charts are listed in the middle of the tab menu such as Column, Line, Pie, Bar, etc.
A drop-down menu of Bar Chart designs will be shown after you click on one of them. , When you put your mouse over the chart option, you'll see a description of what the chart display is good for.
For example, select “2D Bar” in a clustered column for the type of chart.
The chart will appear on the spreadsheet using the data in a 2D form. , To add graph titles or axis titles simply click on the titles tab.
A drop-down menu will appear where you can choose the one you prefer. , by clicking on the text and editing it. , If copy and pasting doesn't work you can always try taking a screen shot of the image and inserting into the selected document.
About the Author
Kathryn Coleman
Committed to making hobbies accessible and understandable for everyone.
Rate This Guide
How helpful was this guide? Click to rate: