Microsoft excel 2010 charts tutorial. How to draw charts in excel 2010 first of all make sure that there is some data in your excel sheet and that your excel sheet does not contain any blank cells between the different columns then click the insert menu and choose the chart type that you wish to draw. You can make a graph in excel 2010 to increase the efficacy of your reports. Choose insert tab select the chart or click on the chart group to see various chart types. Charts from the insert tab.
The data in your excel sheet will be organized as a chart. Simply select the data to chart click the command button for the chart type on the insert tab and then select the style you want for that chart type. Click the insert tab. To create a chart.
Microsoft excel 2010 basic instructions for beginners. These cells will be the source data for the chart. On the left side click column. The goal of these instructions is to familiarize the user with the basics of excel 2010.
Excel 2010 retires the chart wizard and offers you direct access to all the major types of charts on the ribbons insert tab. Virtual workshops and training. 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. Microsoft excels spreadsheets work intuitively forming charts and graphs from selected data.
You can easily change to a different type of chart at any time. We use a gradebook as an example to help the user visualize how different functions can be used. Take a tour download template formula tutorial download template. Gathering data.
Select the cells you want to chart including the column titles and row labels. On the design tab in the type group click change chart type. Select the chart of your choice and click ok to generate the chart. Charts group of microsoft excel 2010.