Stacked Bar Chart in MS Access Form

[Wedgewood]

Group,

I am trying to build a gantt chart in a MS Access for but I can't seem to get it to pick up the second data series.

In excel, you create a stacked bar chart using fields "Key Date" and "Durration" . Once the chart plots you "hide" the "Key Date" field.

In Access I can create a bar chart and then goto "Chart Type" and change the chart from bar to stacked bar.

That's where it gets stuck because it will only include one data series. Does anyone know how to create a stacked bar chart in Access or add a second data series.

Any help would be appreciated. Please advise.

Thank you.

[JConsulting]

Group,

I am trying to build a gantt chart in a MS Access for but I can't seem to get it to pick up the second data series.

In excel, you create a stacked bar chart using fields "Key Date" and "Durration" . Once the chart plots you "hide" the "Key Date" field.

In Access I can create a bar chart and then goto "Chart Type" and change the chart from bar to stacked bar.

That's where it gets stuck because it will only include one data series. Does anyone know how to create a stacked bar chart in Access or add a second data series.

Any help would be appreciated. Please advise.

Thank you.

As far as I know, what you're doing can't be done. Normally MS Project is used in either an Automation using the Project Object or you create your Gant chart in Project linking the data to an access database.

I'm not sure about Access 2007.
J