Line chart labels

[Anonymous]

Hi,

Is it possible to locate the labels of a line chart a bit more separate from the line?

Please see the file attached,

Thank you in advance,

Larisa

[Nicole-Smith]

You cannot control where the labels show up on the chart itself, but you can choose to have them show up on the axis instead:

[Anonymous]

Thank you!

[veidlburkhard]

Hi Larisa,

I think there is a workaround to get what you want by using the dual function.

Seems you have a line chart and marked 'Values on Datapoints' on the expression tab. Call this expression 'expression1'.

In order to get your desired result add a new expression like this: expression2 = Dual(Num(expression1, '# ##0.0'), expression1 + const.) , check 'Values on Datapoints' for this second expression and also 'Invisible'. Now uncheck 'Values on Datapoints' for your first expression. Very important thing is to go to the number tab and mark the 'Expression Default' checkbox for expression2 otherwise the dual function does not work.

The term const. is just the amount you want to shift the 'Values on Datapoints' up or down . If you want you can use a variable vShift instead of conts. and use a slider to adjust the shift easily.

Happy qliking

Burkhard

[Anonymous]

Hi,

I did as you suggested. But the shift (or const.) doesn't work.

Could you please have a look?

See the file attached.

Thank you in advance,

Larisa

[veidlburkhard · Accepted solution]

Hi Larisa,

you did everything fine, but the shift value of 7 you are using is not recognizable with the naked eye. Please use 7000 and change your slider with values from 0 to 10000, step 1000.

With this you'll see the shift...

Regards

Burkhard

[Anonymous]

Thank you! It works.