How to Create a Needle Gauge Chart in Microsoft Word
Question details
The user wants to create a speedometer-style needle gauge chart in Microsoft Word to visually communicate a specific value or status.
- Product
- Microsoft Word
- Device & OS
- not provided
- Scenario
- Visualizing data performance or status using a custom gauge chart in a document.
- Observed behavior
- The user needs a clear method to structure the source data and combine chart types, as Word does not feature a default needle gauge chart option.
Before creating your chart, determine the exact value you want the needle to point to and outline your gauge scales (e.g., poor, average, good). You will need to use a combination of a Doughnut chart and a Pie chart to achieve the speedometer effect.
Create a Custom Gauge Chart using a Combo Chart
Use a combination of a Doughnut chart for the gauge background and a Pie chart for the needle marker to manually create a speedometer chart.
Microsoft Word does not include a native gauge chart template. However, you can create one by inserting a combination chart that layers a Pie chart over a Doughnut chart using the built-in spreadsheet data editor.
Go to Insert > Chart and select Doughnut. In the data window that appears, divide your total gauge into sections (e.g., 25, 50, 25 for Poor, Fair, Good) and add a final bottom half value (e.g., 100) to make it a full circle where the bottom half will be hidden.
Double-click the Doughnut chart to open the Format Data Series pane. Set the 'Angle of first slice' to 270 degrees so the bottom half is perfectly horizontal. Click on the large bottom slice, navigate to the Fill & Line tab, and set it to 'No Fill'.
In the chart data window, add a second data series for the needle. This series needs three values: the needle's starting position (your actual value), the needle thickness (e.g., 2), and the remainder (Total of Doughnut Data - Value - Thickness).
Right-click the chart and select 'Change Chart Type'. Go to the 'Combo' tab. Set Series 1 (the gauge) to Doughnut and Series 2 (the needle) to Pie. Check the 'Secondary Axis' box for the Pie chart series.
Double-click the Pie chart and set its 'Angle of first slice' to 270 degrees to align it with the doughnut. Set all pie slices to 'No Fill' except for the thin needle slice, which you can fill with a solid color like black or red.
Create Custom Combo Charts Easily with WPS Office
WPS Office offers robust charting tools within WPS Writer and WPS Spreadsheet, allowing you to build complex visual layouts like gauge charts seamlessly. It provides a highly intuitive interface for data manipulation and perfect format preservation.
- 1. Insert a Doughnut Chart: Open WPS Writer, navigate to the Insert tab, select Chart, and choose the Doughnut chart. Enter your gauge background data in the pop-up WPS Spreadsheet window.
- 2. Add Needle Data: In the same spreadsheet window, create a second column for your needle data containing the target value, needle thickness, and the remaining scale value.
- 3. Convert to a Combo Chart: Right-click the chart in your document, select Change Chart Type, and set it to a Custom Combo chart. Assign the needle data as a Pie chart on the Secondary Axis.
- 4. Adjust Angles and Colors: Double-click the chart elements to set the 'Angle of first slice' to 270 degrees for both charts. Hide the bottom slices by setting their fill to 'No Fill' to reveal your custom gauge.
Frequently Asked Questions
Why doesn't Microsoft Word have a default gauge chart template?
Gauge charts are highly customized visualizations that require specific data mappings depending on the user's scale. Microsoft Office provides foundational charts (like Pie and Doughnut) so users can build custom combo charts rather than restricting them to a fixed, rigid template.
Can I link my needle gauge chart in Word to an external Excel file?
Yes. Instead of creating the chart directly in Word, you can build the gauge chart in Excel. Once completed, copy the chart, switch to Word, and use Paste Special > Keep Source Formatting & Link Data to ensure it updates automatically when your Excel data changes.
How do I change the colors of my gauge scale sections?
Click twice slowly on an individual slice of the Doughnut chart to select just that segment (avoid double-clicking fast, which opens the formatting pane for the whole series). Then, right-click, choose 'Format Data Point', and change the Fill color to represent your scale (e.g., red, yellow, green).
Why is my pie chart needle not aligning correctly with the background gauge?
This usually happens if the 'Angle of first slice' for both the Doughnut and Pie charts are not exactly the same (usually 270 degrees), or if the total sum of the data values in your Pie chart series does not exactly match the total sum of the data values in your Doughnut chart series.
