Label Dimension

[inescastelhano]

Hi there,

I'm facing a problem building a bar chart.

I have two expressions (1 and 2). For each of them I would like to have a label on the horizontal axis, instead of a legend on the right (as displayed in the picture) but I can't get it to work.

Does anyone have a clue on how to do it?

Thanks in advance.

Cheers,

Inês

[MarcoWedel]

Hi,

you could use the Valuelist function in a calculated dimension and contract your two expressions into one using Pick(Match(Valuelist, ... , ...), ... , ...)

hope this helps

regards

Marco

[Anonymous]

This is an easy one, go to the presentation tab in the object properties and un-tick the "Show Legend" option. This will give the result you need. Hope this works for you.

[MarcoWedel · Accepted solution]

one example:

hope this helps

regards

Marco

[inescastelhano]

Thank you! This is exactly what I was looking for.

It worked perfectly. I didn't know these functions, since I'm still quite new to QV.

Cheers,

Inês

[inescastelhano]

Thanks for your answer However, this would just disable the legend. What I wanted was to get the legend text but in the axis.

Cheers

[Anonymous]

Ok that is also no problem, just click on the object then hold down the Ctrl and Shift key at the same time. Red lines will appear around the elements in the chart. You can then make the bar chart bit a little smaller and wider and you can drag the legend box to thew bottom of the chart. If you make it wide you can then actually get the bits of the legend next to each other.

[Anonymous]

Oh yes and by disabling the legend the names of the expressions will appear under each bar without the need for complex expressions.

[MarcoWedel]

indeed, much simpler.

thank you

regards

Marco