I invite you to visit my online bookstore for more details. 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.

This adds a quick color key to the pie chart that tells which color represents what. Pie Charts are not always the best chart to use to tell your story. Select the chart > Click on the Plus Icon on the top right of the chart > Add Legends. Pie Charts are the most popular charts – to create.

Create pie chart in excel 2007