Adding frills to a Gantt chart

D

ddflip

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.
 
J

Jon Peltier

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
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modify the gantt chart view in project center (WPA) (MS Project 2010) 0
gantt chart in excel 0
Dynamically Scale Gantt Chart Time Scale 2
Adding Baseline1 and Baseline2 on Gantt Chart View 0
Employee Schedule not plotting properly - chart type / data series not correct 0
Using 3 dates in a Gantt Chart 0
Trendline in Stacked Column Chart 2
Trying to add resource allocation data to a gantt chart built in E 0

Top