junkieger.blogg.se

How to make a pie chart in excel 2016
How to make a pie chart in excel 2016






When clicking on the Format Data series, a format menu appears on the right side. Select the chart and right-click a pop-up menu that will appear from that, select the Format Data Series. Once you do that, the chart will look like below. Untick the Chart Title and Legend to remove the text in the chart. Now click on the + symbol that appears top right of the chart, which will open the popup. Select the data table and click on the Insert menu.

how to make a pie chart in excel 2016

We will create a doughnut chart to represent the project status percentage-wise.Ĭonsider the example of the above status of the project and will create a doughnut chart for that.

how to make a pie chart in excel 2016 how to make a pie chart in excel 2016

You can download this Doughnut Chart Excel Template here – Doughnut Chart Excel Template Doughnut Chart in Excel – Example #1įollowing is an example of a single doughnut in excel: Single Doughnut Charts in ExcelĬonsider a project which has three stages like completed, work InProgress, Incomplete.








How to make a pie chart in excel 2016