How Can I Centre the X-Axis Data Labels on a Bar Chart

[PeteL1995]

I've got a bar chart representing financial data over a three year period. The chart itself works perfectly well, however the data labels along the x-axis aren't centred or even aligned to the same point on the bars: 

After looking around online, I can't find a solution on how to resolve this formatting issues. The only suggestion I've seen relates to changing the x-axis to categorical instead of continuous. However, I don't have that option inside of the x-axis:

How can I align the data labels to the centre of the bar chart, or at least to the same position for all bars? 

I'm hoping that I've missed an obvious solutions.

[Anonymous · Accepted solution]

Hi @PeteL1995 ,

Have you drilled for visual objects? Please drill up the visual object to the top level then select the visual object and change the axis type from continuous to categorized.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.