1 2 Previous Next 17 Replies Latest reply on Sep 20, 2018 5:25 AM by Ton Vermeij

    Concatenated list of values in a tool tip for a pie chart

    Felicha Wolf

      I'm trying to concatenate a list of values (example: Super Power) that are attributes of another value (example: Super Hero), and have that concatenated list of attributes appear in a tool tip for a pie chart.

       

      What I get is the familiar asterisk, although I've looked through the community and tried a couple of formulas that were recommended (without success). Most examples I have seen apply to tables of data, but in my case I am not using a table, just a pie chart.

       

      I've attached a packaged workbook with this example.  Can anyone point me in the right direction?

        

      NameSuper Power
      SupermanX-Ray Vision
      SupermanStrength
      SupermanSpeed
      BatmanBatmobile
      BatmanBatcave
      BatmanUtility Belt
      Wonder WomanInvisible Jet
      Wonder WomanLasso of Truth
      Wonder WomanGold Bracelets

       

      Thanks!

        1 2 Previous Next