Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
ddflip
 
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   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Gantt Chart? BChambers Charts and Charting in Excel 1 February 10th 06 07:07 PM
Adding Data Information to a Chart Mike M Charts and Charting in Excel 4 December 17th 05 12:12 AM
Gantt Chart in Excel. Do I need conditional formatting? Shan Charts and Charting in Excel 1 November 16th 05 01:05 AM
adding vertical bars to an embedded chart using VBA Wazooli Excel Discussion (Misc queries) 0 November 15th 05 05:47 PM
Adding a line Chart Type to a stacked-clustered Chart Type Debbie Charts and Charting in Excel 2 January 5th 05 11:25 PM


All times are GMT +1. The time now is 08:18 AM.

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

About Us

"It's about Microsoft Excel"