Visualising data in Access

naa0511217

New member
Local time
Today, 15:16
Joined
Jun 4, 2024
Messages
1
Hi there,

I have recently created an Access database which is used to record patient data. Within my Access database, I have created an 'Outcomes dashboard' where users should be able to view how their patients have scored on measures across their appointments in clustered column chart. The problem I have is that as more data points are added, the columns become so small that it is difficult to visualise the data. Does anyone have any advice on how I can overcome this issue, or have any ideas for alternative ways to visualise data in Access - perhaps by integrating Excel graphs into Access somehow? I do want to keep the graph as a column graph as opposed to another graph type.

1717495160022.png
 
The same would apply to Excel graphs surely?
Perhaps consider a date range?, week, month, quarter etc?
 
Crosspost Change column sizes in modern clustered column chart in Access - Microsoft Community
But indeed, Sophia's response was about the old ActiveX chart control which you should not be using anymore.
Alas, Modern Chart does not seem to have an option for this. You can provide feedback in Access on the Help tab to send a frowny and tell them how you feel. They actually do look at those.
 

Users who are viewing this thread

Back
Top Bottom