![]() ![]() Copy the data, then click the chart and use the Paste Special command. Next, select the data again, categories and values. Step 1 – doughnut chart with data labels Step 2 -Add the same data series as a pie chart Let’s start with some sample data: data for doughnut chart Step 1 – create the doughnut chartįirst, let’s create a doughnut chart straight from the standards, delete the legend, change the wedge colors and add data labels for category and value. With a doughnut chart, you can drag the data labels all you want, but leader lines will not appear. With a pie chart, you simply drag the data labels away from the chart a bit, and, voila! Leader lines. ![]() ![]() But for some obscure reason that totally escapes me, it’s not possible to create leader lines in a doughnut chart. Now, a doughnut chart is basically a pie chart with a white hole bitten into the center. It’s easy to create a pie chart with data labels, pull the data labels away from the pie to create leader lines that link the labels with the wedges. But you’ll need to use a little trick.Įxcel is sometimes a tad inconsistent. In a doughnut chart, you can’t just drag the chart label outside of the wedge to create a label with a leader line.Ĭan leader lines be added to doughnut charts? ![]() If a doughnut chart is just a pie chart with a hole in it, why then does it behave so differently from a pie chart, for example when it comes to creating and positioning chart labels. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |