Home

Graphing Time in MS Access

%3CLINGO-SUB%20id%3D%22lingo-sub-918415%22%20slang%3D%22en-US%22%3EGraphing%20Time%20in%20MS%20Access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-918415%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20graph%20a%20simple%20dataset%20in%20MS%20Access%20that%20consists%20of%20two%20fields%20-%20a%20timestamp%20and%20a%20value.%26nbsp%3B%20The%20timestamp%2Fvalue%20is%20in%2010%20minute%20increments%20so%20there%20are%20about%20100%20values%20in%20a%20day.%26nbsp%3B%20When%20I%20try%20to%20graph%20a%20day's%20values%20in%20Access%2C%20it%20is%20not%20possible%20because%20the%20minimum%20time%20grouping%20is%20one%20day.%26nbsp%3B%20Does%20anyone%20know%20of%20a%20solution%20to%20graph%2Fchart%20by%20hour%20or%20minute%20in%20Access%3F%26nbsp%3B%20There's%20no%20issue%20doing%20this%20in%20Excel%20but%20I%20cannot%20find%20a%20way%20to%20do%20it%20in%20Access%2C%20which%20is%20what%20I%20need.%26nbsp%3B%20Many%20thanks%20for%20any%20guidance%20or%20suggestions.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-918415%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Blendman
New Contributor

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.

4 Replies
I, too, am finding Access graphing "talents" limited if not "limiting".
I wish there was more documentation... Somewhere, with code examples.
With the little experience I have with Access graphs, so far, you might have more success using the old chart control? Than the newer one. You will have to get into VBA programming, IMO, but it will worth your time and, in the end, you'll have the results you expected.

@RogerBreton 

 

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.

Is this difficult?

@RogerBreton 

 

It's very easy.  You can link an Access query right into an Excel sheet and then use all the graphic functionality in Excel.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies