2 Replies Latest reply on Jan 10, 2017 9:19 AM by Jonathan Drummey

    Stacked+clustered bar chart labels

    Amy Clemons Kormendy

      Hello, all--

      I would like to label the stacked sections of my bars separately, so that in the image below, the 2nd bar in each cluster only shows the top value, the 3rd bar only shows the middle value, and the 4th bar only shows the bottom value. Thus, a reader can tell at a glance the percentage decline in each section from milestone to milestone.

      Any tips on how to do this, or even whether it's possible? Thank you!

        • 1. Re: Stacked+clustered bar chart labels

          Hey Amy,

           

          My gut says this isn't possible but our Community consistently surprises me. One hacky way is just to manually add annotations. If you want our Community to take a closer look, please post a packaged workbook with some sample data.

           

          Thanks!

           

          -Diego

          • 2. Re: Stacked+clustered bar chart labels
            Jonathan Drummey

            Because the clusters are created using Measure Names/Values you won't be able to do that kind of customization of mark labels. Even though Measure Names is in the Dimensions window and looks like a discrete dimension in the view it's not really a dimension and we can't access Measure names in calculated fields. You'd need to pivot your data on the 4 measures and then you'd have a dimension you can use to refer to the measure so the right values could be plugged in to the labels. If you need help putting this together then please follow Diego's recommendation to post a packaged workbook with some sample data.

             

            In any case I'd consider using an alternative view because mark sizes vary that can stop labels from being shown, plus having to compare text numbers is harder than using something like bars. I'm not totally sure of the comparison you are trying to make, my first thought using the existing sheet would be to set up a dashboard, put the top/middle/bottom numbers in the tooltips *and* have a separate worksheet that has the top/middle/bottom numbers and then use a Hover Action (either Highlight or Filter) to link between the two sheets. Depending on what you are trying to show, though, there might be alternatives to the grouped/stacked bar chart in the first place that might make the labeling easier.

             

            Jonathan