Others

How to Change Milestone Trend Y-Axis to Percentage in Microsoft Project

Bushra Parveen Oct 1, 2026 868 views

Question details

The user needs to modify the Y-axis of the Microsoft Project Milestone Trend report to display percentages or to include a cumulative actual cost field instead of the default cumulative work.

How to Change the Milestone Trend Y-Axis to Percentage in Microsoft Project

Product: Microsoft Project
Device & OS: not provided
Scenario: Modifying or creating project reports to visualize milestone trends using percentage values or cost metrics.
Observed behavior: The built-in Milestone Report only displays cumulative work and actual cumulative work, lacking native support for an actual cumulative cost field or a percentage-based Y-axis.

Before you start

Ensure your project file is up to date and saved. Since built-in templates are limited, be prepared to create a custom report or use external spreadsheet software for advanced charting.

Solution 1Recommended

Create a Custom Report with Calculated Fields

Build a new custom report within Microsoft Project to track percentages or costs, bypassing the limitations of the built-in Milestone Report.

Microsoft Project's default reports have fixed metrics. To display a percentage or actual cost trend, you need to create a custom report utilizing your own calculated fields.

Create custom fields

Go to the Project tab, select Custom Fields, and create a new Number or Cost field equipped with a formula that calculates the percentage or tracks cumulative cost.

Start a new report

Navigate to the Report tab, click on New Report, and select Chart to generate a blank canvas.

Configure the chart data

In the Field List pane on the right, uncheck the default work fields and select your newly created percentage or actual cost fields.

Format the Y-axis

Right-click the Y-axis on your new chart, select Format Axis, and navigate to the Number section to apply a Percentage format if supported.

Create a Custom Report with Calculated Fields

Data limitations: If MS Project prevents formatting the axis directly as a percentage, ensure your calculated field outputs a decimal (e.g., 0.50 for 50%) before formatting.

Solution 2

Export Data to Excel for Advanced Visual Reports

Use Microsoft Excel or compatible spreadsheet software to generate highly customizable percentage-based charts from your project data.

Free Microsoft Office alternative

Create Professional Milestone Charts with WPS Office

If you are exporting your Microsoft Project data to customize your Y-axis and charts, WPS Spreadsheet provides a free, lightweight, and highly capable environment to build perfect percentage-based visual reports.

1. Export project data: Save your MS Project data as a CSV or export it via Visual Reports.
2. Open with WPS Spreadsheet: Launch WPS Office and open your exported project data file.
3. Insert a custom chart: Highlight your data, navigate to the Insert tab, select Chart, and easily format the Y-axis to Percentage.

Seamlessly opens and edits Microsoft Excel (.xlsx) files exported from Project.Comprehensive charting tools with easy-to-configure Y-axis percentage formatting.Lightweight architecture ensures fast loading of large project data sets.Familiar user interface makes transitioning and generating reports effortless.

microsoft office alternative - wps office

Frequently Asked Questions

Why does the built-in Milestone Trend report only show cumulative work?

The default Milestone Report template in MS Project is hardcoded to track work progress (cumulative work and actual cumulative work). It is not designed to natively incorporate cost or percentage fields without customization.

Can I add cumulative actual cost directly to the default report?

No, the built-in Milestone Report does not support the actual cumulative cost field. You must build a new Custom Report from the Report tab and manually add the Actual Cost metrics.

Is there a better tool for complex project reporting?

For highly customized reports involving percentages, custom axes, or combined cost metrics, professionals often export Project data to Excel, Power BI, or use alternatives like WPS Spreadsheet for advanced data visualization.

How do I format an axis to show percentages in MS Project?

In a Custom Report, select the chart, right-click the Y-axis, and choose 'Format Axis'. Under the Number section, select 'Percentage'. Note that your underlying custom field data must be configured to output proper decimal values for the percentage to display correctly.

Office Quick Solutions