May 04, 2020 Microsoft Office 2016 also commonly known as Office 16 is a productivity suite which is predecessor of Microsoft Office 2019. It’s successor Office 2019 only supports Windows Server 2019 or Windows 10 platform. Activating Microsoft Office 2016 Using a Product Key. Follow these simple steps to activate your Microsoft Office 2016 using a product key. Step 1: Download Microsoft Office 2016 and then run the setup to install the program on your computer like we outlined in the previous section.
A Gauge Chart is a combination of Doughnut chart &Pie Chart in a single chart. The Gauge chart looks like a speedometer which we can find in Cars, bikes, Ac etc. That is why we can call a this Speedometer chart too.
To prepare the Gauge chart we have to use the Doughnut Chart along with Pie Chart. Doughnut Chart: - Doughnut chart is used to show the proportion of the whole. Use it instead of Pie Chart when there are multiple series that relate to a larger sum.
Pie Chart: - This chart is used to show the proportion of the whole. Use it when numbers are equal to 100% and the chart contains only few pie slices (many slices make the angels hard to estimate).
Let’s take an example & understand:
We have a table from Range “A6 to B11”, which is having Zone & Sold unit with total sold unit. Column A contains the Zone Name, Column B Sold, & in cell B11 is having total sold unit. We have another table of Targets & Require sold unit per zone.
To prepare the Gauge chart follow below mentioned steps:-
Select the range “A7 to B11”.
Go to the Insert tab, Select Doughnut Chart from the Chart Group.
Microsoft Office 2016 16 16 18 Gauge
After inserting the Doughnut Chart, select the series of “Total Sold Unit”.
Right click of the mouse pop up will appear, click on Format Data Series.
Format Data Series Dialog box will appear, Select the series option and change the angle to 270 degrees.
Microsoft Office 2016 16 16 18 Gauge Wire
the Total Sold Unit series and fill it with No Fill.
Click on the chart and right click of the mouse click on Select Data.
Select data Source dialog box will appear.
Click on the Add button, Edit Series dialog box will appear.
Click on Series Value, select the range of the next table B16:B18.
Excel will automatically create the new chart Doughnut, we have to change this chart into Pie Chart.
Right click on the chart with the mouse, Select Change the Chart Series.
Select the Check Box of Series 2, Select the Pie Chart from the drop down menu.
Click on ok.
Right click on the chart and select Format Data Series, Choose the Secondary Axis from Series Options and change the angle to 270 degrees.
After changing the angle, in the target series select No fill option from Fill Tab.
In the series of pending units select No Fill option.
Select the series of pointer go to Fill Tab, Choose the solid fill and change the color in black.
Microsoft Office 2016 16 16 18 Gauge Thickness
We will prepare the Gauge chart presentable follow below given steps to prepare the chart more presentable:-
Select the background area of the chart, Fill this area with the white color, and Select the thick box border.
Select the cell K8, we write the formula in this cell for display the %age of achievement in this cell.
Our function will be =ROUNDUP((B11/B18)*100,0)&'%'&' Achieve' and Press Enter on your keyboard.
The function will return the %age of achievement.
16+16 Calculator
This is the way you can prepare Gauge Chart – with the combination of 2 charts Doughnut chart and Pie Chart in Microsoft Excel in 2010 & 2013.