Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
bar chart with two axis
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel chart draws line outside Y axis | Charts and Charting in Excel | |||
Chart Axis Value | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
Stacked Bar Chart with Secondary Axis | Charts and Charting in Excel | |||
Second X axis at top of chart? | Charts and Charting in Excel |