How to make donut charts with percentage in Excel?

When we work with Excel, it becomes easy to combine numerical data in tables and graphs. The truth is that creating combined column charts in Excel and other variants can be very useful. Anyway, if you want something more aesthetic, you should consider making percent donut charts in Excel , something we will show you below .

Index(  )

  1. What is the difference between a donut chart and a sectioned donut?
  2. How to correctly make donut chart with percentages in Excel?
  3. How is a color placed in on the donut chart?
  4. What to do to insert data labels in a graph?
  5. How to create template containing chart in Excel?

What is the difference between a donut chart and a sectioned donut?

Donut charts visually show the percentages of a whole through a circle or circumference. Each part represents a segment of the whole. Thus, you can see what specific percentage each segment has with respect to the general total.

The difference between a donut chart and a sectioned ring is that while the former offers us the representation of the percentages of each of the segments, the latter emphasizes the percentages individually, highlighting them significantly. Clearly, you also have the option of creating a cylinder chart in your Excel sheets and other such actions, but donut charts are usually more convenient.

How to correctly make donut chart with percentages in Excel?

When we decide to show the statistical data results of some important information, it is recommended to make a donut chart with percentages in Excel. This, in addition to being very easy to make, captures the essence of what we want to show.

To efficiently make a ring graph with a percentage in Excel, we must first have the latest version of Microsoft Excel or a recent version of the software on our PC . Now, to start the process, it is essential to have the data of the results that you are going to show and select the cells where you are going to type them.

After the above, click on ‘Insert’ located at the top of your Excel document and there you click on ‘Charts’. At this point, click again on the icon that represents the graphs in a circular shape and select ‘Ring graph’, and you will be able to start customizing the information.

Again we right-click inside the graph and you must click on the option ‘Format data series’. In this option you can give length to your ring, in addition to establishing the color and other aesthetic shapes that will give your graphic beauty and color.

How is a color placed in on the donut chart?

If your goal in doing professional work is aesthetics, then you should put a color in your cells and your ring charts. Undoubtedly, with this process, the segments of your work will look much more attractive in the eyes of those to whom your information is directed.

As for the process to color the chart , start by clicking anywhere within the chart . Now, in the menu that appears, click again on ‘Chart styles’, then go to ‘Color’ and choose from the range of colors those that fit the information you are sharing according to your desire.

What to do to insert data labels in a graph?

To insert data labels in a graph , click inside the graph, click on ‘Add graph element’ and choose how you want to place your label, you can choose between ‘Center’, ‘Inner end’, ‘Outer end’, ‘Call data ‘and’ Perfect fit ‘.

Then under ‘Label format’ you will find ‘Label options’ and ‘Text options’. From there, you will be able to color your label, choose the font and its size, as well as add numbers, bullets and continue to give the data label an original shape in your graph.

How to create template containing chart in Excel?

First you should know that a template in an Excel chart is a document that contains the information of the properties present in it. If you want to save all the numerical elements that your information contains, you can do it as a template.

Simply right click inside the graphic where you will have the option to ‘Save as a template’, choose the name that you are going to put your file and click again on ‘Save’. You will have your information saved in the ‘Template graphics’ folder.

When you need to review or reorder your graph, it will be saved as a template and you can enter new data to carry a sequence or statistics or simply to work on aesthetics and offer a high quality work.

Leave a Comment