Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / October 2005

Tip: Looking for answers? Try searching our database.

Charts

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Glint - 17 Oct 2005 11:47 GMT
Hi All,
I need a very simple line graph to chart a temperature pattern in a course
of time (temperature on the Y axis and the time on the X axis). Simple.
However, simple as it sounds, I have not been able to get the Chart wizard
to do it. I don't need any cummulative figures, or additions or whatever. I
just need the following displayed graphically on a form:
Time         Temp
-------        -------
12:00         32.5
12:37         31.7
13:04         30.8
15:41         28.0
etc.
Can someone please help me out?
Signature

Glint

Douglas J Steele - 17 Oct 2005 12:30 GMT
I just took your sample data, plugged it into a table and inserted a chart
into a form.

Using the wizard, I chose a Line Graph, with the orientation you described.
Yes, the Chart Wizard mangled it completely, but once it was done, I went
back to the properties of the graph, and changed its rowsource from what the
wizard generated to a simple SELECT [Time],[Temp] FROM [Readings] and the
resultant graph looked fine to me.

BTW, Time isn't a good choice for a field name: it's a reserved word, and
using reserved words can lead to problems. I'd recommend changing it to
something like ReadingTime.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hi All,
> I need a very simple line graph to chart a temperature pattern in a course
[quoted text clipped - 10 lines]
> etc.
> Can someone please help me out?
Glint - 17 Oct 2005 13:50 GMT
Thanx Doug,
It never occured to me I could look into the property box. Yes, it does look
"more right", now. The only problem is that the intervals between the points
on the time scale are equal. I want the interval of 20 minutes between 2
readings to be very different from an interval of 2 hours. What should I do?
Signature

Glint

> I just took your sample data, plugged it into a table and inserted a chart
> into a form.
[quoted text clipped - 24 lines]
> > etc.
> > Can someone please help me out?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.