Trying to make a timeline Graph

[homer2002]

Hi All

Has anyone else had trouble making a graph that allows a time line.
Let me explain

I have some data .... say for Example

_________________________________
DateOfSomthing ValueOfSomthing
01/01/01 1
02/01/01 2
04/01/01 3
__________________________________

I use the chart wizard to make a bar/Line graph the usual way,
Insert chart, pick a table, choose the sumof for the y axis, choose the date(by day) for the x axis and no series.

I dont seem to be able to graph this data so that the 03/01/01
appears in the x axis.

This makes it imposible to graph a nice history with peeks and trouphs at the right point.

All my graph does (using the data above) is make a nice straight line and misses out 03/01/01.


How annoying :-(
If anyone can help with this it would be greatly appretiated

 

[darbid]

I hate it when I find the exact question I have and nobody answered them

 

[damian]

Me three!!!

 

[darbid]

Me three!!!

in this thread http://www.access-programmers.co.uk/forums/showthread.php?t=176677

I had a small problem which Bob helped me with. there are some sample MDBs there and this is my take on making a timeline.

 

[CHAOSinACT]

me 4!!! and been searching heaps, all solutions seem to involve spending cash

 

[darbid]

I settled for and have been using a graph in 2003 like in the example thread I showed. It seems to work ok.

 

[CHAOSinACT]

doesn't seem to be openable for me, changed the "download" extension to mdb but access not happy with it, keeps saying it wants another dll?

 

[darbid]

doesn't seem to be openable for me, changed the "download" extension to mdb but access not happy with it, keeps saying it wants another dll?

They should be fine I just downloaded them and they work. You should not be changing the extension as they are already .mdb. Also remember they are not finished examples but relate to a question that I had.

 

[CHAOSinACT]

chrome downloads timeline_a.mdb as timeline_a.download, i swear

 

[darbid]

chrome downloads timeline_a.mdb as timeline_a.download, i swear

I believe you. Maybe try FF or IE. I am sure it is not the first time that Chrome/Google has tried to be different.

 

[CHAOSinACT]

well i won't try to hold that against them this once... i love my chrome!!!! lol

 

[vbaInet]

well i won't try to hold that against them this once... i love my chrome!!!! lol

First time I used Chrome I found it slow so I immediately uninstalled and went back to my Fox

 

[CHAOSinACT]

haven't used fox much but had to go to IE to get those files (thanks btw!) - still scrubbing the still of IE of me!!!(i feel dirty...)

 

[vbaInet]

I've been using Fox for quite a while now. The last time I used IE was like 6 months. You can't do without IE if you do some web dev too lol

 

[darbid]

well i won't try to hold that against them this once... i love my chrome!!!! lol

You have to admit that it is a pretty strange thing that it is doing in this case. If you dont have ff i wouldnt be hittin the old delete button on IE just yet, till google takes over the world. and we are all driving Google cars, powered by Google Gas and we go shopping at Googlemart.

 

[CHAOSinACT]

lmao pretty true... turned out renaming the "download" part "mdb" was correct and chrome did ok - i'm lacking the OWC11.DLL (version 1.0) needed anyway. on access 2007 they no longer support that object on install....