I have a 2 dimension bar chart with 2 expressions.
The expression values are stacked since it has 2 dimension.
I want to display a custom text inside the bars, but only for one of the bars.
When i enable plot data values inside segment, it adds it to both bars, is there a way to make it show only on one of the bar values ?
I want the text to show only on the red bars.
Solved! Go to Solution.
try Instead of your expression "20", change it to dual(Text,20) and check Values on Data Points. Then you can get rid of your expression "Text".
Hope this helps!
I might have not clarify my question properly but
I want to have custom text based on the rw data showing.
showing values works fine with the expression having values on data point enable but i require text, thats where the custom expression comes in, with bar disable. The problem is it, is showing in the other bar also, when i enable Plot values inside segment.
As mention in the first post, its a custom text i'm trying to display and not use the original value used to create the bar.
This is more of a formatting hack rather than using default chart settings.
Thanks, but i have already tried this.
But sadly, its requirements and i cant try alternative to the requested format.
Data wise, its showing all the number/text,
but they want it for the aesthetics.
I am not sure I understand what you mean by 'custom text' could you describe what text values you after and if appropriate the algorithm to create them ?
Best Regards, Bill