Figure 1: Chart with Data Values added as Data Labels Follow these steps to learn how to format the values used in Data Labels within Excel 2011: Select the chart -- then select the Charts tab which appears on the Ribbon, as shown highlighted in red within Figure 2. When you in, you will see that it has its roots in Excel, all the chart data is also stored within an Excel sheet. When you within Excel, the process may not be limited just to changing the values. You many also need to add a new Series or Category. If we use a column chart as an example, Series within your Excel sheet show up as the columns. Categories on the other hand are essentially a set of series. In the sample chart shown within Figure 1, the Series are Grapes, Apples, and Bananas, and, the Categories are the years 2009 through 2012. Figure 1: Chart selected on the slide We will continue exploring our sample chart, as shown in Figure 1, above. ![]() Let us imagine that we want to add a whole new series for Oranges. Let's now learn how we can add and delete Series and Categories: • Open your presentation, navigate to slide containing your chart and select the chart as shown previously in Figure 1. If you don't have an existing chart, in your slide. • Right-click the selected chart, from the context menu, choose the Edit Data option (highlighted in red within Figure 2) to open a sub-menu. In this sub-menu, select the Edit Data option, as shown in Figure 2. Figure 2: Edit Data option within the sub-menu This opens an instance of the Excel sheet containing the chart data, as shown in Figure 3, below. Now, follow these guidelines to add or delete Series or Categories, as required: Add New Series or Category in the End Follow these steps to add a new Series or Category in the end: • Place your cursor on the lower-right corner of the data table so that it turns into a pointer, as shown highlighted in red within Figure 3. Figure 3: Cursor changed • Now click and drag this pointer (highlighted in red within Figure 3, above) rightwards as shown in Figure 4. Figure 4: Drag the pointer rightwards to add a new Series • Type in the values you need. You can see in Figure 5 that we included the name of the new fruit ( Oranges) in the Heading row and then entered some values below. Figure 5: New Series added and edited • Close the instance of the Excel sheet. Centering text in word. You'll see that the new Oranges Series has been added to you chart, as shown in Figure 6, below (compare with the chart in Figure 1, earlier on this page). Figure 6: Chart reflecting the changes after added with new Series • Similarly, to add a new Category in the end, bring up the corner pointer (highlighted in red within Figure 3, earlier on this page) and click and drag it downwards as shown in Figure 7, below. Figure 7: Drag the pointer downwards to add a new Category • Type in the values required. As you can see in Figure 8, below, we typed the year 2013 in the Heading column and then entered some values below. Figure 8: New Category added and edited • Close the instance of the Excel sheet containing the chart data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2019
Categories |