How To Setup The Graph's Y-axis in Report.

[domingsun]

How To Setup The Graph's Y-axis in Report.

When I Key in the data MONTH and SCORE.
the month not following accordingly.
example: i key in Jan first followed by Feb...Mar...
The Graph Displayed the Jan in behind (right)
like ->> Mar Feb Jan
How to fix the y-axis ?

 

[Isskint]

There is a Display in Reverse setting. Right click the axis >>Format Axis>>Axis Options>> Categories in reverse order

 

[domingsun]

Hi,
Thanks for the reply.
still the same problem occured.
my problem is when i key in the data following by month.
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec....
the y-axis arrange with A-Z
it arrange like this :
-> Apr Aug Dec Feb Jan Jul Jun Mar May Nov Oct Sep
A to Z.
now i wan make it follwing the month by Jan to Dec.

 

[Isskint]

from what you say, i guess the values Jan Feb etc are not actual dates but just what you have typed in? The axis will work on smallest to largest (or the other way) OR a to Z (or the other way). If your values are not real dates it will process them as alphabet strings. You would need to change them to real dates (say 1 Jan 13, 1 feb 13 etc?)

 

[emorris1000]

You could just switch them to numbers (1-12) and refer to them as month.

But really you should be able to get it to work normally. What is the data type for the date? If it's String then it won't recognize the values of the months.

 

[Isskint]

If it's String then it won't recognize the values of the months.

Errr, isn't that what I said above??