Using whole number in charts

[f0rg3tfu1]

Good morning,

I am trying to figure out how to show a chart using only whole numbers on the y axis.

The chart is showing a count of instances on the Y axis, and the year on the x axis. My data has various ranges for different groups, but whenever the count is less than 5, it will split up the y axis into .5, 1.5, 2, 2.5 ETC. Can I force this to only use whole numbers?

Thanks for your time!

 

[Madawc]

You could do a formula field that makes a whole number, using either Round or Truncate. (3.8 as either 4 or 3, depending which you use.)

You should be able to use this formula field for your graph. It may depend on your Crystal version, which it is always helpful to give.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[f0rg3tfu1]

Thanks for your reply... but the data going into the chart is a count, so it will always be whole numbers. My problem is that whenever the count is less than the whole number 5 (5,4,3 or 2) that the Y axis will divide itself into units of .5 as below:

3
2.5 *
2 *
1.5 *
1 *
.5 *
0 jan 2000 Feb 2000 Mar 2000 Apr 2000


When I would like it to look like this:

3
*
2 *
*
1 *
*
0 jan 2000 Feb 2000 Mar 2000 Apr 2000

Ideas?

 

[Madawc]

Sorry, I don't follow this. Can anyone else help?

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[Dan3D]

I think there is an "interval size" option in the grids and scales dialog. Bring that up and look at Y-Axis tab and hunt around. If it is there, then you can set it to 1 and maybe get the results you want.

Dan Weingart
OEM Technical Manager
Three D Graphics, Inc.

http://www.threedgraphics.com