Select several different themes and check what changes aboutĪ theme can set fonts, colors, and effects. (There is no Live Preview for charts when On the Page Layout tab in the Themes tab group, open the gallery of Themes.You will need to use Undo to get back to the correct theme after your experiment. The Office theme is not the same as the theme Office 2007-2010 at all! It is not in the list of themes in Excel 20. If you did click on any styles, use Undo to remove any changes. Right click on 88% and then click on Format Data Label.Įxcel 2013, 2016: If you did not click on any styles, move your mouse pointer off the styles gallery. So that it is the only data label selected. 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. Select the text 'Chart Title" and type in Budget 2010 -Inflows.The text box containing the words "Chart Title" is now ready Click on Layout 6, which shows a title, legend at the right, and percentages for the pie wedges:.The name of the layout appears as a popup. Hover over each layout to let Live Preview show what effect it will have on your chart.The gallery of pre-designed pie chart layouts The Chart Tools: Design tab, click the More button beside Chart Layouts or Quick Layout. The legend and change its location on the chart, add a title, show values or percentages for the pie wedges. Plus you can change the colors, show or hide There are several pre-designedĬhart layouts to choose from. 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 Click the radio button New sheet: and enter as the name for the new sheet Chart-Budget.With the chart still selected, on the tab Chart Tools: Design, click the button Move Chart ,.The Move Chart button is not about moving the chart on the worksheet but instead about which sheet tab it should be on. The edge of the chart with your pointer but part of the inside of the Drag to the right until the chart is clear of theĬhart did not move part of chart shifted.The chart still selected (handles are showing), move your mouse over the A chart sheet is different from a normal worksheet. You can drag a chart to an open spot on the current sheet or you can put it on a If necessary, create a folder named excelīudget-2010-chart-Lastname-Firstname.xlsx.In the Save As dialog, navigate to where you will be.Click the Office button or the File tab and then on the command Save As.It certainly needs to be in a different place! Your pie chart may use different colors from the illustration and the legend may be in a different location.Ĭhart. The Chart Tools group of tabs shows as long as Click on Insert tab and then on the Pie Chart button.(You may need to scroll to see column N.) Hold CTRL down and select the range N7:N13, the totals for each row.Select the range A7:A13, the row labels in the Inflow section.To create a chart you first select the data to be charted andĬhart that shows how the Inflow categories compare to the total. This time you will be saving your work as a new file! Create Pie Chart S tart with: budget-2010-Lastname-Firstname.xlsx from previous lesson To format and position data labels - all or single