![make a pie chart in excel 2010 make a pie chart in excel 2010](https://www.officetooltips.com/images/tips/207_2016/1.png)
That's the line from the number to its pie wedge.Ĭlick the data label 88%. The new position should be far enough away that the leader line shows. The mouse pointer is still in the Move shape. The data labels still selected, hover over the The text boxes for percentages at the top left are on top of each other. The font size increases for ALL of the data labels but not for the chart title or the legend text. The % values move so that all are outside the pie shape.Īll data labels are still selected, on the Home ribbon tab, click the button Increase Font Size four times. When you are ready to continue, Undo your changes.Ĭhange the Label Position to Outside End. You can format just one label or all of them. YouĬan use the Mini-Toolbar, the Home tab, or the Format Dataįont sizes, fonts, font colors, background colors, and positions for your data labels. While the data labels are selected, any formatting changes apply only to the labels. The font sizes are small and the numbers that are on a dark color are hard to read. The position, size, color, and font for the labels for your data can beĬhanged from the defaults to make the labels easier to read or to emphasize part of the data.Ĭlick on one of the percentages in the chart.Įxcel 2013, 2016: The Format Data Labels pane appears.
![make a pie chart in excel 2010 make a pie chart in excel 2010](http://www.excel-2010.com/wp-content/uploads/2010/05/rotating-pie-charts-in-excel.gif)
MAKE A PIE CHART IN EXCEL 2010 PLUS
Plus you can change the colors, show or hide There are several pre-designedĬhart layouts to choose from.
![make a pie chart in excel 2010 make a pie chart in excel 2010](https://i.ytimg.com/vi/8lmacWky_lo/maxresdefault.jpg)
You can make a lot of changes to a chart. With its own tab at the bottom and is not on the Budget sheet anymore. The chart now appears on its own chart sheet