Access Sparklines (follow-up on closed thread)

[peglegpete]

Hey guys, the thread linked below helped me a lot in making some reports be a bit more meaningful. (I can't post full link as a new user, but it's to this forum so figured it would not hurt, and that thread is already closed so not many options)

How to add sparklines on an Access report

Because a graphic is more explicit than numbers... Module Source code: Option Explicit '------------------------------------------------------------------------------------------------------------------ 'Object : How to add sparklines on an Access report ' -> SparkLine, SparkBars, SparkOnOff...

www.access-programmers.co.uk

It adds a simple line graph. I am basically tracking 6 months of performance numbers on a bunch of line-items and a mini line graph per line-item is really helpful. However, I'd love it if I could modify the code to make the graphs all have the same min/max scope - as it stands right now, the graphs dynamically use their dataset's min/max for the graph's min/max on.

Hope that makes sense. I'm going to keep trying to modify it myself but it's not working out so far. It would be awesome if we could pull in Philben, the original author of the VBA code, on this conversation but as a new user I don't think I can message him directly. Big thank you to him either way!