471,079 Members | 946 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,079 software developers and data experts.

Stacked Bar Chart in MS Access Form

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.
May 11 '07 #1
1 6403
JConsulting
603 Expert 512MB
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
May 12 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

22 posts views Thread by PeteCresswell | last post: by
9 posts views Thread by Patrick.O.Ige | last post: by
4 posts views Thread by Wayne | last post: by
reply views Thread by turtle | last post: by
14 posts views Thread by Wayne | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.