Forum Discussion
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 ...
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.
