![]() To add an additional series, simply click the Add button and select the additional data that you would like to include. 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. The Select Data Source dialogue box will pop up. ![]() 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). Sometimes you may want to change the selected data. In our example, the 2010 Census Tracts are along the horizontal axis and the population numbers for 20 are the two series, which is what we want. You should double check that this is how you want your data set up. 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. ![]() Select the chart type you want to create by clicking on the type and selecting one of the options from the dropdown menu. 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).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |