By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,850 Members | 972 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,850 IT Pros & Developers. It's quick & easy.

Charts

P: n/a
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

Feb 17 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Br
kevcar40 wrote:
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


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.
--
regards,

Br@dley
Feb 17 '06 #2

P: n/a
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

Feb 17 '06 #3

P: n/a
Br
kevcar40 wrote:
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


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...
--
regards,

Br@dley
Feb 17 '06 #4

P: n/a
Tried that nothing to fix in there

Feb 17 '06 #5

P: n/a
kevcar40 wrote:
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'
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Feb 17 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.