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
Highlighted
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
Highlighted
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.
Highlighted

@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.

Highlighted
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.