EXCEL CHART TEXT LABELS HOW TO

So let`s start the procedure.Ģ) Go to Insert> Charts> click on the drop-down arrow next to Pie Chart and under 2-D Pie, select the Pie Chart, shown below.ģ) Chang the chart title to Breakdown of Errors Made During the Match, by clicking on it and typing the new title.Ĥ) With the chart title still selected, go to Home>Font>click on the drop-down arrow next to fill, and Select More Colors as shown below.ĥ) Select the Custom Tab, from the Colors Dialog box and enter R 204, G 246, B 174 to fill the background of the title with this light green color as shown below and then click Ok.Ħ) With the title still selected, go to Home>Font and change the font to Arial Rounded MT Bold, and the font size to 12 as shown below.ħ) Change the font color of the chart title to R 7, G 102, B 0.Ĩ) With the chart title still selected, go to Home>Font and expand the Font section, in order to launch the Font Dialog box.ĩ) Select the Character Spacing Tab and change the spacing to expanded by 0.5 points as shown below, and click Ok.ġ0) With the chart title still selected, go to Chart Tools>Format>Shape Styles and click on the drop-down arrow next to Shape Effects, then select Shadow>Outer>Offset Diagonal Bottom Right.ġ1) With the actual chart selected, right-click the chart and choose Format Chart Area.ġ2) In the Format Chart Area Panel, go to Chart Options and check the Gradient fill option.ġ3) With the Format Chart Area Panel still open, go to the gradient stops section and click on stop 2 of 4, and then select delete gradient stop.ġ4) Do the same thing for the remaining stop in the middle and delete it.ġ5) There should now, only be two gradient stops left, so now select Stop 2 of 2 as shown below.ġ6) Fill this stop with the White, Background 1, Darker 15% fill as shown below. Here we will combine this two errors in a pie chart. He wants to visually present the main types of errors the player made along with the unforced errors.

EXCEL CHART TEXT LABELS HOW TO

Read More… How to Insert Data into a Pie Chart in ExcelĪ tennis coach at a hypothetical tennis clinic is evaluating the post-game performance of his top-seeded player.

Excel chart text labels