How to Make a Graph in Excel

Step-by-Step Guide

1. 1

   Step 1: Open your Excel 2010 program.

   Typing in a data series requires you to organize your data.
   
   For most people, you will enter items in the first column, Column A, and enter the variables for each individual item in the following columns.
   
   For example, if you are comparing the sales results of certain people, the people will be listed in Column A, while their weekly, quarterly and yearly sales results might be listed in the following columns.
   
   Keep in mind that on most charts or graphs, the information in Column A will be listed on the x axis, or horizontal axis.
   
   However, in the case of bar graphs, the individual data automatically corresponds to the y axis, or vertical axis. , Consider totaling your data in the last column and/or last rows.
   
   This is essential if you are using a pie chart that requires percentages.
   
   To enter a formula in Excel, you highlight data in a row or column.
   
   Then, you click on the Function, fx, button and choose a type of formula, such as a sum. , Use headings in the second row and column to explain your data.
   
   Titles will be transferred to the graph when you create it.
   
   You can enter your data and headings into any section of the spreadsheet.
   
   If you are making a graph for the first time, you should aim to keep the data within a small area so it is easy to work with. ,, Drag your cursor from the top left heading to the bottom right corner of the data.
   
   If you want a simple graph explaining only 1 data series, you should only highlight the information in the first column and the second column.
   
   If you want to make a graph with several variables to show trends, highlight several variables.
   
   Make sure you highlight the headers in the Excel 2010 spreadsheet. , In Excel 2010, the Insert tab is located between the Home and Page Layout tabs. ,, Each type has a small icon next to it explaining what it will look like.
   
   You can return to this chart menu to choose a different graph option as long as the graph is highlighted. , Right click with your mouse and choose “Format Plot Area.” Scroll through the choices in the left hand column, such as border, fill, 3-D, glow and shadow.
   
   Reformat the look of the graph by selecting colors and shadows according to your preferences. , The bar for each item can be either clustered or stacked depending upon how you want to compare the variables.
   
   Each item on the spreadsheet is listed separately in a single bar.
   
   There are no lines connecting them.
   
   If you are using our previous example with weekly, quarterly and yearly sales, you can create a different bar in a different color for each individual.
   
   You can choose whether to have the bars side by side or condensed into a single bar. , If you want to plot data over time, this is the best way to show how a data series has changed over time, such as in days, weeks or years.
   
   Each piece of data in your series will be a dot on your line graph.
   
   The lines will connect these dots to show changes. , This type of graph is similar to a line graph because it plots data on an x/y axis.
   
   You can choose to leave the data points unconnected in a marked scatter graph or connect them with smooth or straight lines.
   
   The scatter graph is perfect for plotting many different variables on the same chart, allowing the smooth or straight lines to intersect.
   
   You can easily show trends in data. , Surface charts are great for comparing 2 sets of data, area charts show changes in magnitude and pie charts show percentages of data.
2. 2

   Step 2: Click on the File menu to open an existing spreadsheet or start a new spreadsheet.

3. 3

   Step 3: Enter the data.

4. 4

   Step 4: Use formulas.

5. 5

   Step 5: Type in a title for the spreadsheet/graph using the first rows.

6. 6

   Step 6: Save your spreadsheet before continuing.

7. 7

   Step 7: Highlight the data that you have just entered.

8. 8

   Step 8: Select the Insert tab on the top of the page.

9. 9

   Step 9: Click on “Charts.” Charts and graphs are both available in this section and are used somewhat interchangeably as visual representations of spreadsheet data.

10. 10

    Step 10: Choose a type of chart or graph.

11. 11

    Step 11: Hover your mouse over the graph.

12. 12

    Step 12: Insert a bar graph

13. 13

    Step 13: if you are comparing several correlated items with a few variables.

14. 14

    Step 14: Choose a line graph.

15. 15

    Step 15: Select a scatter graph.

16. 16

    Step 16: Opt for a chart.

Detailed Guide

About the Author