How to line up Text on axis with bars in chart

[matthewp]

How can i get my text on axis values to line u with the bars in the chart?

The cart has 2 expressions with one bar hidden (the one that has the text on the axis)

can i align this with the first expression?

CURRENT

WHAT I WANT

[Kushal_Chawda]

Write the single Expression:

=Dual( COUNT(DISTINCT S_ID) &'-'& num((COUNT(DISTINCT S_ID)/COUNT(DISTINCT TOTAL S_ID)),'#0.00%'),

COUNT(DISTINCT S_ID))

Check the Value on Data point

[Anonymous]

use calculated dimension with COUNT(DISTINCT S_ID)/COUNT(DISTINCT TOTAL S_ID)

and your expresion will be  COUNT(DISTINCT S_ID)

[Gysbert_Wassenaar]

If you have two expressions then the text-on-axis will be aligned with its own expression, not the other one. But perhaps you can use a combi chart and use Symbol as representation type for the second expression and set the background color of the symbol to a totally transparent color like red(0).

[matthewp]

This is giving me both values on each point

i want % on axis and total on data point

[Kushal_Chawda]

If you have Text on axis expression then just click on + sign and Give text color expression as Black() or red()

[matthewp]

I mean i want it to look like this...

[Gysbert_Wassenaar · Accepted solution]

See attached example.

[matthewp]

[#10]

I'm using the personal edition and am unable to view this file.  Can the solution be explained?

[Gysbert_Wassenaar]

Perhaps this helps: