Combination Charts

[griolfc]

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

 

[Jon Peltier]

Martin -

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

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.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/
_______