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

kevcar40 wrote:[color=blue]
> 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[/color]

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

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

kevcar40 wrote:[color=blue]
> 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[/color]

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

Tried that nothing to fix in there

kevcar40 wrote:
[color=blue]
> Tried that nothing to fix in there[/color]

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