Excel Tutorial Creating Graphs

A step by step excel chart tutorial 1.

Excel tutorial creating graphs. Consider the type of graph you want to make. If you do not see a chart you like click the all charts tab to see all the available chart types and pick a chart. Step 7 give a meaningful title to the chart by editing chart title. Create a chart in excel 2007 2010 2013 and newer versions note.

Select insert recommended charts. Click the button on the right side of the chart click the arrow next to legend and click right. To move the legend to the right side of the chart execute the following steps. In the new versions of excel hover the cursor over a chart type or sub type on the insert ribbon to display a description of the chart.

Formatting to the chart. Select data for the chart. Get your data ready. Follow the steps given to create a chart with quick analysis.

Select a chart on the recommended charts tab to preview the chart. Click the chart type from the charts section of the ribbon see image. The chart will be displayed in your worksheet. Bar displays one or more sets of data using vertical bars.

Lets say you have more than one set of data that you would like to compare on the same chart you can create your basic chart with one set of data then add more datasets to it and apply other items ie. There are three basic types of graph that you can create in excel each of which works best for certain types of data. This tutorial covers all the basics including 1 getting to know the elements of a chart 2 modifying a basic chart to meet your needs 3 applying a predefined chart layout and chart style for a professional look 4 adding eye catching formatting to a chart and 5 reusing charts by creating chart. Click the insert tab.

How to build an excel chart. You can use data labels to focus your readers attention on a single data series or data point. You can select the data you want in the chart and press alt f1 to create a chart immediately but it might not be the best chart for the data. Normally when excel creates a new chart it automatically graphs the data by rows in the cell selection so that the column headings appear along the horizontal category axis at the bottom of the chart and the row headings appear in the legend assuming that youre dealing with a chart type that utilizes an x and y axis.

An advanced chart is a chart that goes beyond the basic charts created by excel. Best for listing differences in data over time or comparing two similar sets of data.