Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-02-2014, 07:21 AM
mtbtomo mtbtomo is offline Gantt bar text labels - possible to put resource hours against the bars? Windows XP Gantt bar text labels - possible to put resource hours against the bars? Office 2007
Novice
Gantt bar text labels - possible to put resource hours against the bars?
 
Join Date: Oct 2013
Posts: 4
mtbtomo is on a distinguished road
Default Gantt bar text labels - possible to put resource hours against the bars?


If I go into bar styles on the gantt chart area, I can select the drop down that allows me to put resource names against each bar.

However, it always shows the percentage allocation
Eg. Design Engineer [80%], Design Manager [20%]

Is it possible to get it to show the hours instead? So that it would say:

Design Engineer [32h], Design Manager [8h]

Percentages mean nothing to me or my colleagues who would be more concerned with budgeted hours than percentage allocations over time.

Or are there any other views that might allow me show programme activities, resources against that activity and each resources budgeted hours?

Thanks in advance to anyone who can help....
Reply With Quote
  #2  
Old 05-02-2014, 09:59 AM
JulieS JulieS is offline Gantt bar text labels - possible to put resource hours against the bars? Windows 7 64bit Gantt bar text labels - possible to put resource hours against the bars? Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Add custom text field in the Gantt chart view.
Customize the field to add the following formula:
[Resource Names] & " " & [Work]/60 & " Hours "

Right click in the Gantt chart to show the shortcut menu and select Bar Styles. Select the bar style for normal tasks, and click the Text tab. Change the field shown on the right to [Text1] or whatever text field you customized. This will show total work.

You may also find the Task Usage view valuable. I will show each task and then a line for each assignment. The view automatically shows work for each assignment.
Reply With Quote
  #3  
Old 05-14-2014, 01:07 AM
mtbtomo mtbtomo is offline Gantt bar text labels - possible to put resource hours against the bars? Windows XP Gantt bar text labels - possible to put resource hours against the bars? Office 2007
Novice
Gantt bar text labels - possible to put resource hours against the bars?
 
Join Date: Oct 2013
Posts: 4
mtbtomo is on a distinguished road
Default

Thanks Julie, I think that's some of what I require. Learnt something new with the custom fields bit from your response for sure.

However, a custom field like this lists all the resources with their percentage allocation and then the total work.

I'm after something more like task usage as you suggest - where the work in hours is against each resource rather than a percentage. But I'd also like to keep the gantt chart view.

Thanks in advance.
Reply With Quote
  #4  
Old 05-14-2014, 05:14 AM
JulieS JulieS is offline Gantt bar text labels - possible to put resource hours against the bars? Windows 7 64bit Gantt bar text labels - possible to put resource hours against the bars? Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

I'm afraid there is no combination of both the Task Usage and Gantt chart. The data in the Gantt chart is pulling from all resources assigned. Only the Task Usage view will show you the individual assignments (resource+ task).
Reply With Quote
  #5  
Old 05-14-2014, 07:19 AM
mtbtomo mtbtomo is offline Gantt bar text labels - possible to put resource hours against the bars? Windows XP Gantt bar text labels - possible to put resource hours against the bars? Office 2007
Novice
Gantt bar text labels - possible to put resource hours against the bars?
 
Join Date: Oct 2013
Posts: 4
mtbtomo is on a distinguished road
Default

Ok, thanks Julie, that was the impression I was getting via a search on google too, but thought I'd ask

Thanks!
Reply With Quote
  #6  
Old 05-14-2014, 01:18 PM
JulieS JulieS is offline Gantt bar text labels - possible to put resource hours against the bars? Windows 7 64bit Gantt bar text labels - possible to put resource hours against the bars? Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Never hurts to ask. You're welcome for the assist.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Gantt bar text labels - possible to put resource hours against the bars? format color of gantt chart bars based on progress? Intruder Project 7 02-02-2014 01:50 PM
Can two sets of task bars be shown on the Gantt? steve@stanley Project 1 07-23-2012 06:03 AM
Making Gantt chart and resource usage views independently viewable in MSP 2007 proj12 Project 1 02-28-2012 06:59 AM
Gantt bar text labels - possible to put resource hours against the bars? Showing Text fields on GANTT and Resource NeoFax Project 4 06-07-2011 08:32 AM
gantt bars with text and i'm losing the bar when i print oompa_l Project 0 11-17-2010 01:16 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 02:47 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft