Forum Discussion
Resources histogram export to excel
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,
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.
Hi Trevor - thanks for replying.. yep that works for me, I finally got it to copy!!