MS Access -- analytics (graphing) addins?

There are very, very few controls which can be embedded in Access, and especially ones that have high end graphing capabilities.

Have you looked into PowerBI (https://powerbi.microsoft.com/en-us/)? While it cannot be embedded in Access, you could perhaps launch it from an Access form.

Thanks for the tips, guys. It blows me away that MS hasn't considered an add-in to Access for better analytics -- it seems like such a natural fit. I'm looking at the ChartFX stuff now and I'm hopeful that they can cut me a deal on something I can integrate into Access now if I let them in on some .NET stuff I'm working on in December. We'll see. In the meantime (and I know I said I wouldn't consider this), what's the success rate of launching the Excel charts API from within Access? This might be a good interim solution, especially if the ChartFX doesn't pan out.

It blows me away that MS hasn't considered an add-in to Access for better analytics -- it seems like such a natural fit.

Excel (and now PowerBI) are their analytics platforms, and the codebases are "owned" by different teams within Microsoft. Suffice it to say that getting those teams to work together to integrate those products would be ... difficult ... at best. Their view is that they already HAVE analytics products, so what's the point of introducing more?

Access was never intended to be used to produce those types of things (charts, graphs, etc). It was intended as a desktop database where users could easily and quickly enter data and produce reports. We (the Access development community) have made Access much, much broader than MSFT ever intended.

" It blows me away that MS hasn't considered an add-in to Access for better analytics "
Stay hopeful. I can't elaborate ... but .....  :-)

Joe -- sounds enticing. I'm definitely hopeful -- ! (I'd be even more hopeful if something were coming out in the next couple of months -- just in time for Christmas, harhar) :)

In the meantime, I figured out how to bootstrap some Excel functionality to at least give some one-way analytics capability -- pivot charts and some other basics. Not pretty but it does the trick for my prototype. I'll close the question and dispense some points shortly for everyone's great comments and feedback. Thanks guys -- !

B

Thanks, y'all, for the assistance on this one. I did take a look at ChartFX but they no longer provide any in-platform support to Access. You can get some pretty charts with outbound data through ODBC but the connection is basically one-way and by then, you're out of Access. Ironically, I did end up eating some crow on this one. I finally ended up using (yep, you guessed it) an Excel instance to get the charts I need. It's still a shade kludgy (good enough for a prototype and about 80% of where I need to be) but I'm actually really pleasantly surprised at the level of control I have from within Access to programmatically create nice-looking pivot charts with a little elbow grease. Looking forward to a next-generation of Access that supports a full-on analytics solution. :)

I'm surprised the CFX does not supply an object model that Access can tap into via VBA.  That is truly sad.