Hi I'm a scheduler who normally uses P6 (although I have used MS Project a little in the past!) I'm working on a tender schedule which has a stipulation to be presented in MS Project... all good so far, schedule built looks good, hits the key dates etc and now I've loaded it out with construction resources (masons/roofers/electricians etc), one of the tender deliverables is to present a resource histogram (showing numbers of operatives/day) of the project resource. I'm looking to export the project resources to excel to produce the histogram and this is where the issue is! The options as I see it are -Export a visual report - I exported a time-phase resource usage report but then hit a brick wall when I tried to manipulate the pivot table data to add a calculated field to convert the hours into a resource headcount as project export to Excel using OLAP cube data which isn't modifiable!Resource Usage View copy & paste - next I tried to straight up copy & paste the raw data from the Resource Usage view into excel to create my own pivot table but unfortunately left clicking to highlight all the date just didn't seem to work - I could highlight and copy the left hand table but the time phase data on the right hand side seems un-copyable, if I highlight it I don't get any copy option on the left click!Export to Excel - next I tried to export the raw data in xlsx format via File/Export/Save Project as File but then am unsure of which fields to set up when mapping to get the resources time phased, I just seem to be able to export the tabular info - Lastly I created a custom report using the in-built graphing tool in Project to create the histogram but this gives a couple of issues - the resource stats on the y-axis are in hours (obviously) with no way of converting to days and more importantly it is in Project and not in Excel as stipulated in the tender requirements! Am I missing something fundamental with this/is it possible? Any help would be grateful - many thanks

Chris,Ok. I make this kind of resource histogram every day from MSP.The easiest way, I find, is to copy the data from the grid in the task usage view or resource usage view. The paste it into excel and graph it there.It's definitely copy-able. You have to set up the timesacale. To make it easy to select and copy, narrow all of the timescale down to about 25%, so the columns all have #### (but the data is still there), then select the first cell and use shift, right arrow on the keyboard to select to the end of the row, ctrl-c.Sure, you can use the built-in reports and/or export data to excel, but I do as above.

Chris_Mercer

Copper Contributor

Jul 15, 2025

Solved

Resources histogram export to excel

Hi I'm a scheduler who normally uses P6 (although I have used MS Project a little in the past!)

I'm working on a tender schedule which has a stipulation to be presented in MS Project... all good so far, schedule built looks good, hits the key dates etc and now I've loaded it out with construction resources (masons/roofers/electricians etc), one of the tender deliverables is to present a resource histogram (showing numbers of operatives/day) of the project resource.

I'm looking to export the project resources to excel to produce the histogram and this is where the issue is! The options as I see it are -

Export a visual report - I exported a time-phase resource usage report but then hit a brick wall when I tried to manipulate the pivot table data to add a calculated field to convert the hours into a resource headcount as project export to Excel using OLAP cube data which isn't modifiable!
Resource Usage View copy & paste - next I tried to straight up copy & paste the raw data from the Resource Usage view into excel to create my own pivot table but unfortunately left clicking to highlight all the date just didn't seem to work - I could highlight and copy the left hand table but the time phase data on the right hand side seems un-copyable, if I highlight it I don't get any copy option on the left click!
Export to Excel - next I tried to export the raw data in xlsx format via File/Export/Save Project as File but then am unsure of which fields to set up when mapping to get the resources time phased, I just seem to be able to export the tabular info -

Lastly I created a custom report using the in-built graphing tool in Project to create the histogram but this gives a couple of issues - the resource stats on the y-axis are in hours (obviously) with no way of converting to days and more importantly it is in Project and not in Excel as stipulated in the tender requirements!

Am I missing something fundamental with this/is it possible?

Any help would be grateful - many thanks

TrevorATperfectproject
Jul 17, 2025
Chris,
Ok. I make this kind of resource histogram every day from MSP.
The easiest way, I find, is to copy the data from the grid in the task usage view or resource usage view. The paste it into excel and graph it there.
It's definitely copy-able. You have to set up the timesacale. To make it easy to select and copy, narrow all of the timescale down to about 25%, so the columns all have #### (but the data is still there), then select the first cell and use shift, right arrow on the keyboard to select to the end of the row, ctrl-c.
Sure, you can use the built-in reports and/or export data to excel, but I do as above.

Forum Discussion

Resources histogram export to excel

3 Replies

Resources