How to create a Dial (gauge) Graph and Dashboard in Access? (1 Viewer)

[Setare]

Hi -

I am currently using Access 2010 and have created several pie, line and column charts. However, I am looking into finding a way to create a dashboard (not a Main Menu or switchboard) in Access. It looks like I can't create a dial in Access 2010 using a doughnut chart. Although I was able to create one in Excel 2010. If I upgrade to Access 2019, will I be able to create a dial chart (speedometer) and a dashboard there?

Thanks in advance for your recommendations,
Setare

 

[isladogs]

No. Neither are built in options so you would have to create your own

 

[Setare]

Thank you very much for your quick response. Have you used or heard of the 3rd party software, "Dashboard Builder" for Access?

Thanks,
Setareh

 

[isladogs]

Sorry but no.

 

[MajP]

See solution

Speedometer Dashboard

Hi All, I am wanting to add a dashboard form with multiple speedometers to display progress and project health. Is there an example that someone could share with me. Cheers Mick

www.access-programmers.co.uk

 

[arnelgp]

nice dashboard, but how can i call it in Report (object variable or With block variable not set).

a static dashboard with report.

 

[MajP]

Yes that was my suggestion in the original post, to do it this way. I just did not feel like drawing those.

The better option is to use a set of images and store them in the database. I think you could make it look nicer and would give you more options for use. This could actually allow you to have progress bars in a continuous form