How to Distinguish Tender and Live Project Resources in Microsoft Project
Question details
The user needs a way to visually distinguish resource allocations between live projects and tender projects in Microsoft Project.

- Product
- Microsoft Project
- Device & OS
- not provided
- Scenario
- Viewing and formatting resource allocations for different types of projects (live vs. tender) within the software.
- Observed behavior
- The built-in Resource Graph lacks sufficient formatting options, such as custom bar styles and labels, to effectively separate the two project types.
Ensure you have Microsoft Project installed and access to a spreadsheet application like Microsoft Excel or WPS Spreadsheet to process the exported data.
Export Project Data to a Spreadsheet for Advanced Charting
Since Microsoft Project's built-in Resource Graph and Reports lack advanced visual customization, exporting your resource data to a spreadsheet allows you to build charts that clearly differentiate project types.
Microsoft Project's Resource Graph is inherently limited in its bar styling and labeling capabilities. By moving the data to a dedicated spreadsheet tool, you gain complete control over how the live and tender resource allocations are displayed.
Open your Microsoft Project file. Go to 'File' > 'Export' and choose to save your project data as an Excel Workbook (*.xlsx).
Open the exported file in your spreadsheet software. Organize your resource data into two distinct columns or categories labeled 'Live Projects' and 'Tender Projects'.
Highlight the organized data, navigate to the 'Insert' tab, and select a 'Stacked Bar' or 'Column Chart'. This will visually separate the resources based on the project type.
If this is a recurring report, you can record or write a VBA macro within your spreadsheet software to automatically format the exported data and generate the chart with a single click.

Easily Visualize Exported Project Data with WPS Office
While Microsoft Project restricts your graphical reporting capabilities, you can easily export your resource data and use WPS Spreadsheet to create stunning, customized charts. WPS Office is a highly compatible, free alternative to Microsoft Office that handles complex datasets and advanced charting effortlessly.
- 1. Install WPS Office: Download and install WPS Office for free to access WPS Spreadsheet.
- 2. Open your exported data: Launch WPS Spreadsheet and open the .xlsx file you exported from Microsoft Project.
- 3. Create your resource chart: Use the built-in Insert Chart feature in WPS to design a customized graph separating your live and tender project resources.

Frequently Asked Questions
Can I add custom labels to the Resource Graph in Microsoft Project?
No, the built-in Resource Graph in Microsoft Project has limited formatting options and does not currently support custom bar labels for differentiating project types.
Does the custom Reports feature in Microsoft Project allow separation of live and tender projects?
Unfortunately, the custom Reports feature in Microsoft Project is also limited in this regard and does not provide enough customization to effectively separate live and tender project resource allocations visually.
Is it possible to automate the chart creation after exporting project data?
Yes. By exporting your data to a spreadsheet program, you can write a VBA macro to automatically format the data and generate separated resource charts whenever you run the export.




