 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / February 2006Charts
Hi I have a chart in form the 'X' axis is in time values ie 06:00 - 07:00, 07:00 - 08:00, 08:00 - 09:00 .....etc over a 24 hour period Access is returning this on the chart starting at 00:00 - 00:01 i would like the chart axis to start at 06:00 - 07:00 and and at 05:00 - 06:00 can anyone give me any suggestions on how to force access plot in this way thanks kevin > Hi > I have a chart in form the 'X' axis is in time values [quoted text clipped - 12 lines] > > kevin Not sure exactly where, but double-click on the chart in design mode and check out the MS Graph properties. I'm sure you can set the axis range. If you still have difficulty I'll try and take a look for you at a later time.  Signatureregards, Br@dley Br@dley thank you for your reply i know with a cross tab query you can force the axis layout in a chart the result is in the row source but i cant figure out how to do this with a simple query thanks again kevin > Br@dley > thank you for your reply [quoted text clipped - 5 lines] > > kevin You don't. You need to change the graph properties as I mentioned before, otherwise it uses defaults. (double-click the graph object to open MS Graph. Then look in the options for the axis... Signatureregards, Br@dley Tried that nothing to fix in there > Tried that nothing to fix in there Kev, Double click on the value axis and look at the 'Format Axis' dialog that appears. There will be a tab called 'Scale'. Turn off the auto check box and mess with the values for either 'minimum' or 'Category (X) axis crosses at' SignatureTim http://www.ucs.mun.ca/~tmarshal/ ^o< /#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake /^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me |
Reply to this Message |
 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.