Access 2010 VBA - multiple overlayed graphics RRS feed

  • Question

  • I'd like to create a stacked bar chart from one table and then overlay two line charts from different tables over top of the bar -- essentially showing three variables in different ways. Is there a way to overlay graphic types in Access 2010?   If not, then can it be done with Access controlling Excel?


    Tuesday, February 24, 2015 10:20 AM


  • If you create a resulting query, which has all three variables in it, why not. The process is the same as in Excel. Create the stacked bar chart for all the tree variables, then go to chart Design view, choose consequently the second and the third series and change chart type to line.

    Of course, if you want more flexibility, beauty and other whistles, you can use Excel Automation to do this within Excel from Access.

    Andrey V Artemyev | Saint-Petersburg, Russia

    • Marked as answer by Caillen Monday, March 9, 2015 5:40 AM
    Tuesday, February 24, 2015 10:30 AM