To create a chart, select the data that you want to be charted (if the data is in non-adjacent cells remember to hold down CTRL), go to the Insert Chart tab and in the Charts group, and select the type of chart you want (Column, Line, Pie, Bar, Area, Scatter, or Other).
Select the chart type you want to create by clicking on the type and selecting one of the options from the dropdown menu. When you click on a chart, the data that shows up on the horizontal axis is highlighted in purple, whereas the data in in each data series is highlighted in blue.
You should double check that this is how you want your data set up. In our example, the 2010 Census Tracts are along the horizontal axis and the population numbers for 2000 and 2010 are the two series, which is what we want.
Sometimes you may want to change the selected data. There are multiple methods of doing so.
The first way to change the selected data is by clicking on the chart area to select the chart and then click on Select in the top Charts ribbon toolbar (specifically in the Data tab).
The Select Data Source dialogue box will pop up. You can enter the new desired range of data in the Chart data range box, or you can edit individual series listed in the Series box by clicking on the desired series and then entering the new data accordingly in the boxes on the right. To add an additional series, simply click the Add button and select the additional data that you would like to include.
You’ll notice in our example that the series are called Series 1 and Series 2. We can change the series names by editing each series. After selecting the series that you want to edit, type the new name of the series in the Name box on the right or select a cell from the worksheet.
You can also edit the horizontal axis labels by clicking into Category (x) Axis box and selecting the values in your spreadsheet.
The following image displays the Select Data Source dialogue box with the name of 'Series 1' changed to '2000.'
Another way to change the selected data is to press CTRL on the keyboard while clicking on white space in the Chart Area. Then, in the dropdown menu that shows up, click Select Data...
The Select Data Source dialogue box will pop up again, and the chart data can be changed as it was in the first method.
You can also insert a chart without selecting the data first. The chart will appear empty because you haven’t selected the data for the chart.
To select the data you will need to go to the Charts toolbar and click on Select Data. You can enter the range of data in the Chart data range box.
Make sure the cursor is in the Chart data range box and then select the data you want to graph.
After you’ve selected your data, you’ll see that the Series box, the Y values box, and the Category (X) axis labels box all have the data in them.
Move your mouse onto the chart and wait a second. Small labels will appear telling you which part of the chart your cursor is on (chart area, plot area, vertical axis, horizontal axis, or legend). There are tutorials on how to format each of these areas, which you can jump to by clicking on the links.
When you create a chart, 3 new tabs appear above the Ribbon under the heading Chart Tools. The tabs will disappear when you are not working on the chart. To access them, click on the chart.
The tabs are designed to help you format and edit the appearance of the chart. We’ll go over the Chart Tools Tabs more in depth later (link here), but if you continue on to the next sections, we will cover most of the features you will likely be using.