Others

How to Change Chart Axis Labels in Microsoft Planner

Ayan Masood Sep 30, 2026 869 views

Question details

The user wants to replace the default built-in chart axis labels in Microsoft Planner with custom values such as Urgent, Important, Medium, and Low.

How to Change Chart Axis Labels in Microsoft Planner

Product: Microsoft Planner
Device & OS: not provided
Scenario: Attempting to customize task priority labels on the built-in charts within a Microsoft Planner dashboard.
Observed behavior: Microsoft Planner does not natively support editing or replacing the default chart axis titles and labels.

Before you start

Verify that your Microsoft Planner account has permission to export plans, as you will need to export your data to a spreadsheet tool to create customized charts.

Solution 1Recommended

Export Planner Data to a Spreadsheet for Custom Charting

Because Microsoft Planner does not natively support editing chart axis titles, you can export your plan data to a spreadsheet application to create a fully customizable chart with your required labels.

This workaround allows you to utilize the powerful charting tools found in spreadsheet software to manually rename axes, adjust data labels, and format colors to match your exact project management needs.

Export the Plan

Open your Microsoft Planner board, click the three dots (...) at the top of the plan to open the More menu, and select 'Export plan to Excel'.

Open the Exported File

Locate the downloaded .xlsx file on your computer and open it using a compatible spreadsheet program.

Insert a Custom Chart

Highlight the task data columns you want to visualize, navigate to the 'Insert' tab, and choose a chart type (such as a Bar or Column chart).

Edit Axis Labels

Right-click the chart axis, select 'Select Data', and edit the Horizontal (Category) Axis Labels to your custom values like Urgent, Important, Medium, and Low.

Export Planner Data to a Spreadsheet for Custom Charting

Data Sync Limitation: The exported spreadsheet is a static snapshot of your plan. Future updates made in Microsoft Planner will not automatically sync to this file.

Solution 2

Submit a Feature Request to Microsoft

If you want the ability to edit chart axis labels natively added to Planner, submitting a feedback ticket directly to Microsoft is the best approach.

Free Microsoft Office alternative

Create Customizable Task Charts with WPS Office

Need to create detailed charts from your Microsoft Planner data? WPS Office is a free, lightweight alternative to Microsoft Office. You can easily open exported Planner data in WPS Spreadsheet to customize your chart axes, labels, and layouts without an expensive subscription.

1. Install WPS Office: Download and install WPS Office for free on your PC or Mac.
2. Open Exported Data: Launch WPS Spreadsheet and open the .xlsx file you exported from Microsoft Planner.
3. Customize Your Chart: Highlight your data, click 'Insert', and select 'Chart' to easily build graphics with custom axis labels.

Free and lightweight complete Office suiteFully compatible with Microsoft Excel (.xlsx) and CSV formatsAdvanced charting tools to easily customize axis labels, titles, and legendsFamiliar user interface for seamless migration

microsoft office alternative - wps office

Frequently Asked Questions

Why can't I edit the chart axis titles directly in Microsoft Planner?

Microsoft Planner's built-in charting tool is designed for quick, standardized overviews and currently lacks advanced customization features. Modifying axis labels natively is not supported.

What format does Microsoft Planner use when exporting a plan?

When you export a plan from Microsoft Planner, it automatically downloads as a Microsoft Excel (.xlsx) spreadsheet containing all your task details, progress, and priority statuses.

Can I use WPS Office to edit my exported Planner data?

Yes, WPS Spreadsheet is fully compatible with .xlsx files. You can seamlessly open your exported Planner data, create custom charts, and rename axis labels to fit your needs.

Office Quick Solutions