A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Adding frills to a Gantt chart



 
 
Thread Tools Display Modes
  #1  
Old March 2nd, 2006, 05:46 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Adding frills to a Gantt chart

I've created a Gantt chart showing elapsed time from application to
acceptance of a request. Since it covers over 3 years there isn't paper big
enough to be able to identify even an approximation of the dates. In
addition, some instances only have an application date and no acceptance date
so there is no bar at all. Is there some way to place an indicator for the
start date and (if available) the end date. And in a perfect world, would it
be possible to print the date above the plot point (allbeit in a tiny font)?
Thanks in advance for any help.
  #2  
Old March 3rd, 2006, 03:40 AM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default Adding frills to a Gantt chart

You might find something here that you can use:

http://peltiertech.com/Excel/Charts/GanttChart.html

And if you can locate a marker anywhere, you can apply a label to it:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______


"ddflip" wrote in message
...
I've created a Gantt chart showing elapsed time from application to
acceptance of a request. Since it covers over 3 years there isn't paper
big
enough to be able to identify even an approximation of the dates. In
addition, some instances only have an application date and no acceptance
date
so there is no bar at all. Is there some way to place an indicator for
the
start date and (if available) the end date. And in a perfect world, would
it
be possible to print the date above the plot point (allbeit in a tiny
font)?
Thanks in advance for any help.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mix chart types Ken Murray Powerpoint 7 April 28th, 2006 02:50 AM
Update Visio Gantt Chart MDunigan Visio 0 December 16th, 2005 03:35 PM
Multiple filter query of form truepantera Using Forms 6 August 4th, 2005 08:26 AM
How do I create a gantt chart in Visio 2002 that spans across page Eric Visio 2 January 17th, 2005 10:29 PM
Gantt chart Charts and Charting 4 January 6th, 2004 04:18 AM


All times are GMT +1. The time now is 06:30 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.