How do I display a chart in an Access form?

[AccessBeetle]

Hello all,
I have an Access module that uses data in a table to create additional information that is then placed in a new Excel workbook and worksheet.
Using that information I create a simple Gantt chart using Excel’s stack bar chart. The problem I’m having is displaying the chart in a form. I’m currently doing it by saving the new workbook to a file then displaying the file via an unbound object link. Seems like there should be a way to avoid the file save process and just display the new workbook’s chart directly on the form.
Thanks for Help!!

[rwalle]

Hello all,
I have an Access module that uses data in a table to create additional information that is then placed in a new Excel workbook and worksheet.
Using that information I create a simple Gantt chart using Excel’s stack bar chart. The problem I’m having is displaying the chart in a form. I’m currently doing it by saving the new workbook to a file then displaying the file via an unbound object link. Seems like there should be a way to avoid the file save process and just display the new workbook’s chart directly on the form.
Thanks for Help!!

Hi ABeetle:
under Design tab there is a tool to insert Charts into forms , is a wizard like the one you have in MS exel,you pick your data source: (table ,query) choose the fields, the chart style you want and thats all, I based my charts on queries that was filtered on date fields so I can see my variables behavior trough the time, once you place your chart in the form , you can customize it clicking on its properties,