December 13th: Total labels (only) on top of stacked bar chart

Assume that you have a crosstab like this:

mceclip0.png

Now you want to turn it into stacked bar chart with labels, and you might end up with something like this:

mceclip1.png

However, you would like only the Totals to show in the label - and only on top of the bars.

You can do this by adding a calculation to your object, and then showing labels for this calculation as an invisible line in the stacked bar chart.

In my example, I have added a Total calculation, sum(all, 0, m1) to my data:

In a stacked bar chart, this would now look like a chart with four series of data. I have made sure to add a label to the Total calculation only:

From the Chart tab, you can select the Total series and turn its Visualization into a Line - however, a Line with no line and no marker.

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.