Click the Edit button to display the Edit Series dialog box (shown in Figure 5-23).ġ0. In the Legend Entries (Series) section, at the bottom left of the Select Data Source dialog box, select Series 1 from the list.ĩ. We need to correct the legend information display, and we want to use the category information to add a title to the chart.Ĩ. We see in Figure 5-22 that the Chart data range, ='Sales By Category'!$A$2:$C$5, is correct, and we do not want to switch the row/column orientation. The Select Data Source dialog box contains functions to set the data range for the chart, to switch row/column orientation, to assign a range that contains the data values for the chart series, and to assign a range that contains the legend information. The Select Data Source dialog box will appear, as shown in Figure 5-22. Go to Chart Tools > Design ribbon, and choose the Select Data command, as shown in Figure 5-21.ħ. With the Macro Recorder still running, select the pie chart if it's not already selected.Ħ. With a couple of quick adjustments, we will modify the legend to show the month name only, and we'll add a title to the chart showing the product category. Excel combined the first two columns of data and created the legend from them. The pie chart is displayed, but as Figure 5-20 shows, it is not exactly what we might have expected. On the Insert ribbon, select Pie from the Charts section, as shown in Figure 5-19. On the Insert ribbon, select Pie from the Charts section, as shown in Figure 5-19.Ĥ. Select the data range that contains the data for the Baked Goods & Mixes category (A2:C5), as shown in Figure 5-18.Ĥ. Create a new macro and name it MakePieChart.ģ. Select the Sales By Category worksheet.Ģ. Then we'll explore options to reuse the code and automate the creation of pie charts for each product line.ġ. The chart will show the monthly sales for the category. In this example, we are going to create a pie chart based on the data for one product category.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |