 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General PowerPoint Questions / February 2007Floating Bar Gantt Chart
I'm trying to develop a chart in my ppt that will display projects across fiscal years. What I would specifically like is something like the illustration below with the bars for each project placed based on start date, end date, and duration. ---------------------- ! Project 1 Title ! ---- a bar for project 1 ---------------------- -------------------------- ! Project 2 Title ! --- a bar for project 2 -------------------------- ------------------------- ! Project 3 ! ---- etc. ------------------------- ---------------------------------------------------------- Jan 2007 July 2007 Jan 2008 Jun 2008 I've created my cells in the datasheet that have start date, end date, and duration across the columns, and the project titles in the rows, but I can't get the bars to display properly, based on the minimum, maximum, major unit, minor unit on the y bar. Can this be done? And if so, how do I set it up? Thanks Steve Hi, I think you only need 2 sets of data. Start date and duration. The end date is in effect calculated by the chart. Although this article is aimed at Excel the techniques use apply to MSGraph. http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=343 Cheers Andy > I'm trying to develop a chart in my ppt that will display projects across > fiscal years. What I would specifically like is something like the [quoted text clipped - 24 lines] > > Steve Working with a powerpoint 2000 chart, I can't seem to get it to work. I have 4 columns in my table. A is tasks, B is start, c is end, and d is duration. Tasks are displayed by row - each with a start date, end date, and duration. When I display this in the chart, I get three bars, one for start, one for end, and one for duration. Not sure what I need to do different in the setup. Steve > Hi, > [quoted text clipped - 35 lines] > > > > Steve Double click the EndDate column, this is not required as the stacking of start and duration will/should give you the end date position. Cheers Andy > Working with a powerpoint 2000 chart, I can't seem to get it to work. I > have 4 columns in my table. A is tasks, B is start, c is end, and d is [quoted text clipped - 62 lines] >>> >>>Steve |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.