View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default bar chart with two axis

Do you want a Gantt chart?

http://pubs.logicalexpressions.com/P...cle.asp?ID=343
http://peltiertech.com/Excel/Charts/GanttLinks.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


wrote in message
ups.com...
Hi,

I am trying to create a chart that looks something like this:


process1 process2 process3 process4
project a 9/11/2006 10/9/2006 11/6/2006 11/20/2006
project b 9/11/2006 10/9/2006 11/6/2006 11/20/2006
project c 9/15/2006 10/13/200611/10/200611/24/2006
project d 10/30/200611/27/2006 12/25/20061/8/2007

and then on the value (y) axis have dates listed( at half intervals,
1st of the month and 15th of the month) listed
or
have just each month listed.

basically each project has its own time line, every project has the
some process but at different dates.

i have been spinning my wheels on this all day to get a pretty chart.
with no luck, on getting the exact information in the right place so it
all makes sense.

if anyone has any ideas. i would appreciate it very much.