Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-28-2014, 02:27 PM
wildzero wildzero is offline Resource List displayed in Gantt Chart - Anyway to wrap text? Windows 8 Resource List displayed in Gantt Chart - Anyway to wrap text? Office 2013
Novice
Resource List displayed in Gantt Chart - Anyway to wrap text?
 
Join Date: May 2014
Posts: 2
wildzero is on a distinguished road
Default Resource List displayed in Gantt Chart - Anyway to wrap text?

Hello! I am currently working on a project which in some cases has 15-20 resources assigned to a single task. I have to display the resources in the Gantt chart, but when I print the schedule the text is too small due to 20 resources listed for one task.



To be clear, I am referring to resources listed within Bar Text in the Gantt Chart, not in columns (I have already hidden the resource column).

Does anyone know of a way to wrap Bar Text within the gantt chart?

Last edited by wildzero; 05-28-2014 at 03:12 PM. Reason: Edited for clarity
Reply With Quote
  #2  
Old 05-28-2014, 06:10 PM
TrevorR TrevorR is offline Resource List displayed in Gantt Chart - Anyway to wrap text? Windows 7 64bit Resource List displayed in Gantt Chart - Anyway to wrap text? Office 2010 64bit
Novice
 
Join Date: Mar 2014
Posts: 1
TrevorR is on a distinguished road
Default

You could use Format, Bar Styles to change the text on the bars from resource names to resource initials.
However, I would say that any task with 20 resources assigned probably needs to be chopped up into smaller pieces, so that each task has only 2 - 3 resources assigned (unless they are the members of an orchestra or something like that).
Reply With Quote
  #3  
Old 05-28-2014, 07:41 PM
wildzero wildzero is offline Resource List displayed in Gantt Chart - Anyway to wrap text? Windows 8 Resource List displayed in Gantt Chart - Anyway to wrap text? Office 2013
Novice
Resource List displayed in Gantt Chart - Anyway to wrap text?
 
Join Date: May 2014
Posts: 2
wildzero is on a distinguished road
Default

Thanks for the response.

Yeah, initials won't work. Not an orchestra, but not far from it in terms of size.

Agreed that typically a task should not have that many resources assigned - I assumed I would get that response - but this is a special case where I am building out a high level schedule for the next few years in which each task is a project in and of itself (though not an integrated project schedule as each task does not have a schedule built out yet), and each project affects multiple teams which is what I am trying to show.

With that said, any ideas on how I could show up to 20 resources for a task in a way that can be easily digested in a print out? Open to any ideas, doesn't have to be Bar Text.

Thanks
Reply With Quote
  #4  
Old 05-29-2014, 05:46 AM
JulieS JulieS is offline Resource List displayed in Gantt Chart - Anyway to wrap text? Windows 7 64bit Resource List displayed in Gantt Chart - Anyway to wrap text? Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

If it is a high level project, would it be possible to use the Resource Group field instead of individual resource names? Enter department or job description data for each resource and modify the bar styles to show resource groups.

The text field next to the bars cannot be wrapped.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Resource List displayed in Gantt Chart - Anyway to wrap text? Gantt bar text labels - possible to put resource hours against the bars? mtbtomo Project 5 05-14-2014 01:18 PM
Resource List displayed in Gantt Chart - Anyway to wrap text? Generate chart from list of text values knownunknown Excel 6 04-24-2013 01:56 AM
Resource List displayed in Gantt Chart - Anyway to wrap text? Making the second line of text in a numbered list wrap back to the left margin aaron12345 Word 1 06-19-2012 05:29 PM
Making Gantt chart and resource usage views independently viewable in MSP 2007 proj12 Project 1 02-28-2012 06:59 AM
Resource List displayed in Gantt Chart - Anyway to wrap text? Showing Text fields on GANTT and Resource NeoFax Project 4 06-07-2011 08:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:10 PM.


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