How can I format the x axis – decimal places/ date format?
9 October, 2012
Hi,
I have a chart in which the Count (y-axis) need only show whole numbers (decimals don�t make sense in the context of the data being displayed). I�ve set the Decimal Places property of the Axis Style to zero, but the chart still seems to render an incorrect Y scale (refer to the Y scale displayed on the 2 screen shots below). How do I configure settings to display only whole numbers on the Y axis? In the example below, the Y scale should simply be 0, 1, 2, 3, 4.
Also, can you please let me know how to set the date format of the X scale so that it does not display the time component of the data (e.g. display 01/02/2012 rather than 01/02/2012 12:00 AM).
Thanks in advance for your help,
Michael C.
I have a chart in which the Count (y-axis) need only show whole numbers (decimals don�t make sense in the context of the data being displayed). I�ve set the Decimal Places property of the Axis Style to zero, but the chart still seems to render an incorrect Y scale (refer to the Y scale displayed on the 2 screen shots below). How do I configure settings to display only whole numbers on the Y axis? In the example below, the Y scale should simply be 0, 1, 2, 3, 4.
Also, can you please let me know how to set the date format of the X scale so that it does not display the time component of the data (e.g. display 01/02/2012 rather than 01/02/2012 12:00 AM).
Thanks in advance for your help,
Michael C.
Hi Michael,
It looks like your scaling is set to 'automatic' which does not allow you to change the decimal places of the axis.
Can you please go to 'Scale' and enter a whole number as your scale unit?
e.g. 1 , 5 etc..
In regards to the time being visible on the axis, this may be related to the datatype of the field itself.
Can you try changing the format of this field at the view level, as outlined in the post below:
Changing the date format
Please let me know how you go.
Regards,
David
It looks like your scaling is set to 'automatic' which does not allow you to change the decimal places of the axis.
Can you please go to 'Scale' and enter a whole number as your scale unit?
e.g. 1 , 5 etc..
In regards to the time being visible on the axis, this may be related to the datatype of the field itself.
Can you try changing the format of this field at the view level, as outlined in the post below:
Changing the date format
Please let me know how you go.
Regards,
David
Thanks for your help David - the X and Y axis are now displaying the way we want.
Regards,
Michael C.
Regards,
Michael C.