Create A Graph In Excel

| February 27, 2012 | 0 Comments

Microsoft Excel can be used to create graphs to sort data and present it in a way that is visually appealing. Microsoft Excel allows you to easily create graphs that can be used in presentations, or to just help you track expenses or other figures in an eye-catching manner. Charts are an effective way for us to quickly visualize data. In the following example, we are going to create a graph in Microsoft Excel to track some expenses for the month of February.

Create Charts In Excel

To begin, launch Excel and open a new workbook. To create a new workbook, click the File tab and select New from the menu, and then select Blank Workbook. Type a heading above each column. In the example below, we are using Expense and Amount for our headings.

create a graph in excel

In the left column of your Excel workbook, type the name of the expenses on separate lines. In the right column, type the amount of each expense. Be sure not to skip columns, as your data may not appear in the graph. If you need to re-size the width of the column, you can by dragging the separator between columns and sliding it over.

create a chart in excel

Next, left-click, drag and highlight only the data, as we did above. Do not highlight the headings, or they will be included in the graph.

create graphs in microsoft excel program

From the ribbon menu, select the Insert tab, and then choose the type of chart you want to create from the options in the Charts menu.

excel pie chart

In this example, we are selecting a simple pie chart. As you can see, there are many different options, including various 3-D pie charts. Experiment to see which works best for you.

excel chart

Once you make your selection, you will see that the chart is populated based on the information we typed into the cells. You can clearly see the breakdown of our expenses at a glance.

Creating Charts In Microsoft Excel

You are not limited to simple pie-charts. Some of the other popular charts are bar charts, column charts, line charts and scatter charts. Choose the type of chart that suits your needs and graph your data. For more Excel tips, be sure to read our other Office tutorials.

Category: Office

Dave

About the Author ()

Dave has been providing free computer repair and tech support advice online since 2002. Join us on our forums and be sure to subscribe to our newsletter for weekly tips and other helpful computer articles. Connect with me on: Google+

Leave a Reply

Your email address will not be published. Required fields are marked *