Oct 17 2019 03:50 PM
I am trying to graph a simple dataset in MS Access that consists of two fields - a timestamp and a value. The timestamp/value is in 10 minute increments so there are about 100 values in a day. When I try to graph a day's values in Access, it is not possible because the minimum time grouping is one day. Does anyone know of a solution to graph/chart by hour or minute in Access? There's no issue doing this in Excel but I cannot find a way to do it in Access, which is what I need. Many thanks for any guidance or suggestions.
Oct 19 2019 01:15 PM
Oct 20 2019 02:16 AM
Thank you for your reply. I have figured out that the best way to do graphing is to link the Access data into Excel and do the graphic there as Excel has much better graphing functionality.
Oct 22 2019 04:30 AM
It's very easy. You can link an Access query right into an Excel sheet and then use all the graphic functionality in Excel.