Hi,
Ive got a graph which is very small but has a lot of bars on it, using a category scale. Obviously theres no way all the labels will fit so im trying to hide some.
From various forum posts ive seen that I should set the Label property on my category group to either the value i want or an empty string for the ones i want to hide. This part works but when the graph is rendered the labels are still too small and get cropped even though the labels next to them are blank.
See attached image.
Below is the expression im using on the CategoryGroup Label:
= IIf(Fields.Band =
"8Hz"
Or Fields.Band =
"16Hz"
Or Fields.Band =
"31.5Hz"
Or Fields.Band =
"63Hz"
Or Fields.Band =
"125Hz"
Or Fields.Band =
"250Hz"
Or Fields.Band =
"500Hz"
Or Fields.Band =
"1kHz"
Or Fields.Band =
"2kHz"
Or Fields.Band =
"4kHz"
Or Fields.Band =
"8kHz"
Or Fields.Band =
"16kHz"
,
Fields.Band,
""
)
I also tried Null instead of empty string but it didnt change anything.
Is there something I can change to get it to render the labels correctly? Or is there some other approach i should be using? I considered a numerical scale and using the step value to skip some labels but there doesnt seem to be a way to override what text is displayed in that case.
Thanks,
Martin