P6- export to excel to make histogram

In the Open Standard

David SmithMember for 22 years 6 months

Created: 10 Dec 2008, 09:23
: 4
: 1

Hello again,

My daily question. Have worked out how to get histograms in P6 (yet to work out how to make stacked ones, still on one resource at a time or overall histo).

B I want to export the resource loading into excel to make the histogram there. I have used some of the resource loading reports and have even modified them in the wizard, but they still do not give out the right numbers.

anyone have a method of exporting their resources to excel?

many thanks in advance

Dave

Save Follow Follow forum Report

Reply New topic

4 replies

Oldest first

0
James Shimmon · 17 years ago
#1
Use the resources tab on the left, sort out the timescale you want in the spreadsheet view to give hours/whatever time period, highlight the top resource, hit CTRL+A - this will select everything, CTRL+C to copy, then paste into Excel
Report
0
David Smith · 17 years ago
#2
James,

Can not quite make out what you mean by that. can you please go into a little bit more detail.

Would really appreciate it.

Thank you in advance

Dave
Report
0
James Shimmon · 17 years ago
#3
In your activities view, on the left hand side there is a button to view ’Assignments’ - when you are in this screen you can manipulate it to show whatever you like - it will show your budgeted units for each of your resources that are assigned to activities.
Fire me your email address and I will do some screenshots for you to demonstrate
Report
0
A D · 17 years ago
#4
Go to File --> Export; in the new window select spreadsheet (XLS) and then in the next window tick mark on the resources. U can add filter and sort options

Cheers,
Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?