Hi

I need to create a chart that:
1) tracks number of hours posted by different teams against dates
2) shows different phase of a development cycle against dates

The first element is okay, we've managed to do that. A simple line
graph showing each teams number of hours tracked against a date
column.

The 2nd element - what I want is columns, spanning across the dates,
for the different phases.

Any suggestions?

Thanks

Martin


--
griolfc
------------------------------------------------------------------------
griolfc's Profile: http://www.excelforum.com/member.php...o&userid=25453
View this thread: http://www.excelforum.com/showthread...hreadid=388984

Martin -

You want columns? Most times this is shown in a Gantt chart using bars (horizontal):

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

Perhaps you have a particular way you want the chart to look. Could you describe the
appearance of the columns?

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

griolfc wrote:

Hi

I need to create a chart that:
1) tracks number of hours posted by different teams against dates
2) shows different phase of a development cycle against dates

The first element is okay, we've managed to do that. A simple line
graph showing each teams number of hours tracked against a date
column.

The 2nd element - what I want is columns, spanning across the dates,
for the different phases.

Any suggestions?

Thanks

Martin