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/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
>
>