How to create an interactive donut chart in an Excel sheet

Who I am
Philippe Gloaguen
@philippegloaguen
EXTERNAL REFERENCES:

vgr.com gamedesigning.org Reddit.com

Author and references

Graphs are undoubtedly an essential element to be included in Excel tables and documents, because through them it is easier to understand the information which are present in our document. It is for this reason that we want to teach how to create an interactive donut chart on an Excel sheet.

By inserting charts in a cell in Excel we can access many types of charts, each of them tries to adapt to different needs. We have the classic bar graphs, peak graphs, and of course the ring-shaped graphs. If you would like to use a donut chart , be sure to read the following information.



How to create an interactive donut chart in an Excel sheet

How to create an interactive donut chart in an Excel sheet

To follow the following tutorial, you need to have a table with the various data already established or create a pivot table in Excel. Likewise, we recommend that you use the donut chart only in tables that don't contain too much data .

To insert an interactive donut chart into an Excel sheet, follow these steps:

  1. Once you have finished the whole board, you can apply a donut chart, which will greatly improve the look of your board.
  2. The process for inserting a donut chart is fairly straightforward in the latest versions of Microsoft Excel. The first thing to do is to go to the section of insertion, located in the options section at the top of the screen.
  3. Find the section graphics, in particular you have to click on the graphics option with a circular shape.
  4. In this section various options will be shown, the one you are interested in this time is ring, click on ring.
  5. The chart should appear in your Excel table, located at the point that seems most convenient to you, in the same way you can change its size.
  6. Once you are happy with the look of the table, right click on it. All options related to this chart will appear on the screen, you need to click select data ...
  7. A dialog box about the data in the table will appear. At the top is the data range of the chart . Click this option and select all the data you want to include in this donut chart, click the accept option.
Read How to change the function of a bad key to a good one with KeyTweak

After the above steps, you will have the foundation of your ring-shaped artwork. In any case, if you don't like the final overall look, you can configure it to your liking by inserting a legend in the Excel chart or by following some of the steps that we will mention below.



Customize the graphics of the ring

The donut graphics are quite eye-catching and very intuitive, using them will highlight the look of your board a lot, but you can go further. In fact, you can improve the appearance of Excel charts and the donut chart is no exception to this rule. To change the formatting options within this chart, follow these steps:


  1. If you want to customize the ad chart ring that you created earlier, right click on the ring.
  2. The options related to the chart will appear on the screen, click on the option to format the dataset.
  3. A new panel will appear on the right of your screen that you can configure to your liking, use the different options that will appear in according to your tastes , in this way you can give a personal touch to your new graphics.
  4. As a final section, remember that you can have your chart have an automatic update in Excel, something highly recommended for most charts of any nature.
add a comment of How to create an interactive donut chart in an Excel sheet
Comment sent successfully! We will review it in the next few hours.