Microsoft Excel 2010 Graph Tutorial

Choose insert tab select the chart or click on the chart group to see various chart types.

Microsoft excel 2010 graph tutorial. In the charts group select the desired chart category column for example. On the left side click column. Select the data for which you want to create the chart. Among its many features microsoft excel enables you to incorporate charts providing a way to add visual appeal to your business reports.

Select the chart of your choice and click ok to generate the chart. On the design tab in the type group click change chart type. These cells will be the source data for the chart. We use a gradebook as an example to help the user visualize how different functions can be used.

Virtual workshops and training. Select the cells you want to chart including the column titles and row labels. Charts group is one of the most useful groups of microsoft excel 2010 and it has been improved and came around with some new features which were not available with the excel 2007. Take a tour download template formula tutorial download template.

Before you start proceeding with this tutorial we are assuming that you are already aware of the basics of microsoft excel. This tutorial will cover data entry formatting formulas and functions and graphs. Below is a screenshot to present how a graph looks like in ms excel 2010 worksheet. Charts group of microsoft excel 2010.

You can easily change to a different type of chart at any time. The goal of these instructions is to familiarize the user with the basics of excel 2010. To create charts for the data by below mentioned steps.