By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,667 Members | 2,073 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,667 IT Pros & Developers. It's quick & easy.

Stacked Bar Chart in MS Access Form

P: 1
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
Share this Question
Share on Google+
1 Reply


JConsulting
Expert 100+
P: 603
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.