Select any cell in the range that contains data that is used by the chart.Create your chart as usual ( you can use the sample data below).To create your self expanding chart in Excel 2007 and Excel 2003 do the following Let’s look at Excel 2007 and Excel 2003 first. So, in Excel 2007 we can use a new table feature if you need the workbook to be backward compatible with previous Excel 2003 versions you need to do a few more clicks to get the same result. We can allow a chart to automatically accommodate new data as it is added. But, by a few tweaks and Excel magic, we can set up a chart differently. Normally a chart is set up to only display what is currently on the datasheet. So, it is really easy to create a self-expanding chart in Excel.

I will show you how to create a self-expanding chart. Choose the option Add Data Labels.Hello Excellers, welcome back to another Excel tip today. Without the data labels it is difficult to understand what each slice indicates.ġ) Move the mouse over the chart for which you want to add data labels.Ģ) Right click the chart. The slices are the figures or the units sold (10, 20, 30 etc.). It shows the slices, the title and the legend (apr, may etc.).

You will have to add or remove Data labels on your own. When you insert a Pie chart on your worksheet, it will show different slices, a title and a legend, without the data labels. The data labels make a chart easier to understand. You can use this option to analyze the data.Īdd or Remove Data Labels to a Pie Chart (Excel 2007)ĭata labels are data (or figures) associated with each slice. Double click a particular slice, hold and drag it out to separate it from the other slices. You can separate a Pie chart slice (or all the slices). There are other features associated with the Pie chart, which you can use to enhance user experience. Next, hold the Ctrl key, click the 3rd column (ruler) and drag the mouse till the last row. Click the mouse on the first column, first row and drag the mouse down until the last row. Similarly, you can create another chart by choosing the next column’s data (that is ruler), along with the first column data.

How do you create pie chart in excel