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.
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.
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.
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.
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.
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.