akpprinting.blogg.se - Process to make a pie chart in excel

In the “Select Data Source” window click on “Add” to enter a new “Legend Entries” and select the “Values” column from the third data table.

For this, right-click on the chart and then click on “Select data”.

Now, the next thing is to create a pie chart with a third data table to add the needle. After this, you’ll have a chart like below.

Again you need to hide below half of the chart by using “No Fill” for color and I've also added a color scheme for the labels.In “Select Data Source” window click on “Add” to enter a new “Legend Entries” and select “Values” column from the second data table.At this point, you’ll have a chart like below and the next thing is to create the second doughnut chart to add labels. For the rest of the fours data points, I’ve used fours different colors (Red, Yellow, Blue, and Green).For this, click on only that part of the chart and open “Format Data Point” and select “No Fill”. After this, you need to hide below half of the chart.In “Format Data Series”, enter 270° in “Angle of first slice” and hit enter.From here the next thing is to change the angle of the chart and for this right click on the chart and then click on “Format Data Series”.

Once you click OK, you’ll have a doughnut chart just like below.After that, select the “Value” column from the first data table. In the “Select Data” window, click on “Legend Entries” and enter “Category” in the name input bar.Now, right-click on the chart and then click on “Select Data”.First of all, go to Insert Tab ➜ Charts ➜ Doughnut Chart ( with this you’ll get a blank chart).To create a SPEEDOMETER in Excel, you can use the below steps: