2 Replies Latest reply on Jan 27, 2018 3:28 PM by Chris Nelson

    Label stacked bar by the name of biggest section of the bar?

    Chris Nelson

      Is it possible to label a stacked bar by the name associated with the biggest section of that stacked bar?

       

      For example, I have the following simple table:

       

       

      SKUNameTotal
      A12Zag-Zig25
      A12Zaggy5
      A12Zagzig15
      B9VBop5
      B9VBopper5
      B9VBoppino12
      B9VBoppy4
      C3P0Twiddy12
      C3P0Twiddler55
      C3P0Twidster

      95

       

      The names are different synonyms for the same SKU. So, for product A12, it goes by Zag-Zig, Zaggy, and Zagzig. What I'd like to do is be able to stack all the totals for each sku into a stacked bar, but then label that bar by the synonym that has the highest total.

       

      So, in the example above, we'd have 3 stacked bars, for the three SKUs, A12, B9V, and C3P0. The bars would total 45, 26, and 150 respectively. And they would be labeled "Zag-Zig", "Boppino", and "Twidster", because those are the names that have the highest totals for each SKU. Here's how it might look when rendered (rough Photoshop mockup):

       

      bar_sample.jpg

       

       

      Is this possible? The stacking of the bars is straightforward, but I'm hitting a block trying to figure out how to label each bar with the name with the synonym with the highest total.