Excel displays a number of options that control where your data labels are positioned.
Click the Add Chart Element drop-down list.(This will appear when the chart is selected.) Make sure the Design tab of the ribbon is displayed.To add data labels in Excel 2013 or later versions, follow these steps: Select the position that best fits where you want your labels to appear.In this example, well use the Columns command. Hover over each Chart option in the Charts group to learn more about it. Select the cells you want to chart, including the column titles and row labels. In this example, we use the Summary worksheet. Make sure the Layout tab of the ribbon is displayed. Select the worksheet you want to work with.Activate the chart by clicking on it, if necessary.To add data labels in Excel 2007 or Excel 2010, follow these steps: For instance, if you are formatting a pie chart, the data can be more difficult to understand if you don't include data labels. Depending on the type of chart you are creating, data labels can mean quite a bit. I invite you to visit my online bookstore for more details.Data labels are used to indicate what the main part of the chart represents. To print only the chart: Select it and then make your changes in Print Preview – Page Setup.įind the Excel Video Lesson that you want – Index to all Excel Topics News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase.(You will see multiple “handles” around this slice.) Click on the border of the slice and drag it away from the Pie. After a short pause, select the slice that you want to “explode” to choose it. To “explode” a pie slice, first select the Series “Total” – the Pie.Select the Plot Area and drag the sizing handles to enlarge it.On the Data Labels tab, select Percentage and Category Names. Select the Chart Series “Total” – the Pie – and format it.Format the “Plot Area.” Remove the Border and change the Background to White.Select the Chart Element and then click the Format Chart Element Icon on the toolbar.Use the Drop-Down menu on the Chart Toolbar to become familiar with each Chart Element.(If your chart is on its own worksheet, select that worksheet tab.) Select the chart first so that you can format it.Here are the steps to follow in this Excel Video Lesson: In this video I will demonstrate how to format your Pie Chart – and “explode” it! The people who create charts want to create Pie Charts and they want to “Explode” slices of the pie. Pie Charts are not always the best chart to use to tell your story. Pie Charts are the most popular charts – to create.