Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.charting
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.



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
Excel chart draws line outside Y axis pc Charts and Charting in Excel 2 July 24th 06 01:36 AM
Chart Axis Value Thiem Charts and Charting in Excel 1 November 2nd 05 10:32 PM
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis [email protected] Charts and Charting in Excel 0 July 13th 05 09:30 PM
Stacked Bar Chart with Secondary Axis Benjamin B Charts and Charting in Excel 7 May 15th 05 04:00 AM
Second X axis at top of chart? Phil Hageman Charts and Charting in Excel 1 December 29th 04 01:48 PM


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

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"