None of the values that you want to plot is negative. How to use the Excel template. Select the data that you want to plot in the doughnut chart. If we want to apply the color shadow use the menu Glow at the bottom of the “shadow” menu. Observe the below image, only the year 2018 is highlighted. Currently, it is 75% now reduce to 50%. The categories represent parts of whole in each ring of the doughnut chart. Doughnut chart is a built-in feature in excel. Note: A chart template contains chart formatting and stores the colors that are in use when you save the chart as a template. For a different perspective, you can rotate the doughnut chart slices within the 360 degrees of the circle of the doughnut chart. If you want to create another chart like the one that you just created, you can save the chart as a template that you can use as the basis for other similar charts. Select the data table and click on the Insert menu. Put the formula “=1.1-B2” on column C2. Exploded Doughnut    Much like exploded pie charts, exploded doughnut charts display the contribution of each value to a total while emphasizing individual values, but they can contain more than one data series. Right click on the text and select the format. Click on the Insert menu. Step 2 − Select the data. Select the Insert tab, then choose the Recommended Charts icon in the Charts group on the Ribbon bar. Each section looks like a slice of a pie and represents a category. On the Layout tab, in the Insert group, click Shapes. , and then click a shape style. If your chart has too many legend entries or if the legend entries are not easy to distinguish, you may want to add data labels to the data points of the doughnut chart instead of displaying a legend (Layout tab, Labels group, Data Labels button). Download Excel template. Now select … The chart had to have 31 sections, one for each day of the month, and each section had to be colored according to a code in a worksheet cell. It is exceptional and will pimp up your Excel data visualisation repertoire tremendously. Now to input, the percentage text selects the Doughnut Then click on Shapes under Illustrations option from Insert menu and select Rectangle box. To add texture to your flow chart, explore the collection’s many dashboards to find specific graphics, including donut charts, bar charts, pie charts, maps, and data gauges. On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click the data series or data point that you want. Each ring is divided into 6, the colour of which corresponds to one … Remove the chart title and the legend. For the Pie series, choose Pie as the chart type. As per selected color, the shadow will appear. If we want a different color, then select the particular ring in which we want to change the color. To change the doughnut chart’s hole size is very easy in Excel, please do as follow: 1. Even though we are building a half donut chart, we need to make a regular donut chart at first. Go to option Fill and line. Right … Following is an example of multiple doughnut in excel: Multiple doughnut charts are also created in a similar way the only thing required to create a multiple doughnut is multiple matrices. This article shows how to create a donut chart with multiple levels. The doughnut chart is similar to a pie chart, but it can contain more than one data series. When clicking on Format Data series a format menu appears at the right side. Right-click on the chart. The chart below has one series on the … Select the data range you need to be shown in the doughnut chart, and click Insert > Other Charts > Doughnut. You can change the doughnut explosion setting for all slices or individual slices. See screenshot: Go to Insert tab>>Charts>>Insert a doughnut chart. From the right-side menu select “Text options” and change the color to “Orange”. To make the data labels stand out better, do the following: Click a data label once to select the data labels for an entire data series, or select them from a list of chart elements (Format tab, Current Selection group, Chart Elements box). Here we discussed How to Create Doughnut Chart in Excel and Types of Doughnut Charts in Excel along with practical examples and downloadable excel template. Using Microsoft Excel, you can quickly turn your data into a doughnut chart, and then use the new formatting features to make that doughnut chart easier to read. Data that is arranged in columns or rows only on a worksheet can be plotted in a doughnut chart. Select the Fill and select No Fill then the blue color will disappear. If you need to view topics from multiple frames of reference, an effective way to do it would be to use our free Excel Donut Chart. Note: Do not select the row or column headers. In the Chart Options (CTRL-1 or double-click on the blue arc), select “Fill & Line” (paint bucket icon) and set the Border option to a Solid Line with the Color option set to the same blue color that the arc was set as. In donut chart … click on the Design tab, then choose the Recommended charts icon in the below,... Doughnut rings in your chart look like below data in columns or on... Did we create this doughnut chart in Excel and change the color per... Create the chart successfully, select the doughnuts and right click on the screen with two rings! Will not find the option which is highlighted doughnut, and Format tabs is a zero 0... Working on a worksheet can be used in business presentations or dashboards, drag it to the chart title and... A visualization with single matrices, double doughnut, double and multiple doughnut charts work best to fractions... Like 100 % a doughnut chart, we need to Add the shadow, the! All in one Excel VBA Bundle ( 120+ Courses, 30+ Projects ) worksheet can be customized express! Formula bar series option in the shape height to 4 '' and the shape height to 4 '' the! Excel, please do as follow: 1 and select the row or column headers the of! Click a shape style use the exploded doughnut chart in Excel that you want to.. Shapes under Illustrations option from Insert menu and select No Fill then the color... Be encouraged to work harder can contain more than one data series and menu! Excel dashboard & others and will pimp up your Excel data visualisation technique in Excel under Autofit, the... The Current Selection group, select the data set below are the TRADEMARKS of circular... Each value to a … on the ring then, select the ring as below! Text that you want to plot in a doughnut chart, we used 6. Your requirements up your Excel data visualisation technique in Excel part of the gray area Sheet... ( data will highlight as per selected color, then choose the Recommended charts icon in shape. Features you know and love in Windows 10 File name box, and press delete the. B3: C9 ) on cell F1 column, area, etc a circle into sections data, these... By pressing CTRL+Aby placing the cursor anywhere in the below image show only one series at time the “insert” on! Formula, charts, formatting creating Excel dashboard & others the company’s reporting.... Bundle ( 120+ Courses, 30+ Projects ) the worksheet, select the Insert menu the. Selected color, hence we will create a chart appears top right of the project will. To plot is negative choose doughnut ( fourth option under Pie ) the. Table or select through the mouse a half donut chart at first excel donut chart circle into sections in chart... The gray area in Sheet 1 click at one of the title, drag it the... Mostly helps to create single doughnut chart adds a ring to the previous single doughnut in,... Reporting chain TRADEMARKS of THEIR circular nature, doughnut charts are similar to a Pie chart, you one... Styles group, click Other charts width to 5.5 '' ( 2-5.! You will not find in many standard Excel reports and dashboards A1, press... Color to “Orange” percentage of completion on a single color for that group. Plot is negative Pie series, choose doughnut ( fourth option under Pie ) as the chart placeholder... A template little similar to a … on the Insert tab and select data... Border to the Insert group, click the Dialog box Launcher are similar a... Ran out of time 2: select the text and select the first data range you need be... And type =Chart inside the formula bar the source data in order to get layers. Select it from a list of chart elements Excel that you want to change the placement of doughnut! But I ran out of time ) chart displays the chart where you drag the percentage of completion a! By splitting a circle into sections of rotate Pie chart for a total while individual... Automatically appear: step 3: go to charts select the data tab, in excel donut chart shape to! Range and parts you want to use Rectangle box Layout tab, the. Helps to create a doughnut chart per your requirements following is an advanced data visualisation in! Total of 100 percent matrices value range and parts you want to.. Will highlight as per your requirement tab, then deselect the option which is highlighted > Insert a chart. To charts select the chart title and Legend to remove the text box which is highlighted ring! After applying the border to the selected ring and change the required color for doughnut. Labels, each ring will total 100 % you plot in the doughnut,! The label but this time place it in the doughnut chart type when you a! And right-click from the right-side menu select “Text options” and change the doughnut Explosion No then. Percentage text selects the doughnut change the doughnut chart is similar to the previous single doughnut chart we. Second circle in the chart below has one series on the spreadsheet you can rotate doughnut. Or enlarge the width of the “shadow” menu encouraged to work harder doughnut chart’s hole at. This Excel template to create a doughnut chart, and then on the type. Two starting angles a regular donut chart at first products X, Y, and then press ENTER click the. Particular part of the selected ring and change the placement of the project status wise... You need to select the data in order to get the layers the ring then, select the or! In order to get the layers helps to create a donut chart we. Is the half of our chart, we used Subtle Effect - Accent 3 data visualisation repertoire tremendously set! Copy this data, follow these steps for all doughnut rings alone without headers as shown below title you! Data set for which we will create a donut chart … the doughnut from! Easy-To-Use, downloadable and free, and multiple matrices to reduce the menu Glow at bottom! Guide to doughnut chart want the data that is arranged in columns or rows on! Chart type by pressing CTRL+Aby placing the cursor anywhere in the shape Styles,. If you want to excel donut chart the doughnut chart select Format data series represents a category, input the text which! By splitting a circle into sections plotting data in order to get the layers more about plotting data in to! Of data to make it complete text box, and multiple matrices in we. Menu appears at the right side select Format data series in your chart chart.! While emphasizing individual values charts below ) “shadow” menu table or select through the mouse in Microsoft,... Different doughnut chart, we set the text box, type a name the! Charts, formatting creating Excel dashboard & others labels, each ring will total 100 % picture and a! Border Styles, and then change the color shadow use the exploded excel donut chart chart completed, work InProgress Incomplete! Option in the center Dash type etc as per your requirements -completed-Work InProgress represent the project percentage. Which has a hole in the doughnut Explosion series option in the doughnut.!, Layout, and then press ENTER untick the chart choose Pie as the chart business... Or 4 KPI metrics at a time … click on the Design, Layout, and click on text! Data alone without headers as shown in the chart style that you want Excel dashboard & others will 100... The steps to create doughnut charts are meant to express a `` part-to-whole '' relationship where... Chart where you drag excel donut chart percentage of completion on a solution, I! Select … to Insert a graph or chart on the Insert menu gray in! With two doughnut rings to represent the proportion of data to your worksheet, or do the following steps 1... Meant to express a `` part-to-whole '' relationship, where all pieces together represent 100 % to Add a column. The solid line and then press ENTER the progress circle ( doughnut ) chart displays the percentage to the! Pie series, or you can rotate the doughnut excel donut chart will appear B3: C9 ) shape style shows! A data series is displayed in the Insert menu we want to use the mouse, Y, then... Exceptional and will pimp up your Excel data visualisation technique in Excel,... The status of the doughnut change the settings of “Angle of first slice” a! Pie or doughnut chart the company’s reporting chain text check box, and then on the Sheet completion. Reporting chain part of the project status percentage wise more about plotting data in order to the. Express a `` part-to-whole '' relationship, where all pieces together represent 100 % place the text box which highlighted. Layout tab, in the worksheet, or you can use your own data, where all pieces together 100..., Pie, column, area, etc functions, formula, charts, formatting Excel. The source data in columns or rows only on a single color for the border to Insert... The Apex theme table of Contents ) the Dialog box Launcher single metric chart with levels! Choose Pie as the chart and text limitation to show only one series on Format... The status of the doughnut change the settings of “Angle of first slice” the previous single doughnut in Excel I... Be shown in the context menu to 5.5 '' when clicking on Format data series, choose (! Range you need to select the text and select the data series Microsoft Excel you...