4 Replies Latest reply on Oct 10, 2013 11:28 AM by Kris Erickson

    How can I create dynamic axis based on filter selection?

    Dharmesh Purohit

      Hi all,

       

      How can I create dynamic axis based on filter selection?

       

      I have data like this :

       

      MonthProduct 1 Sale (%)Product 1 Sale($ M)Product 2 Sale (%)Product 2 Sale ($ M)
      Jul-1137%$3756%$56
      Aug-1138%$3857%$57
      Sep-1137%$3757%$57
      Oct-1137%$3755%$55
      Nov-1138%$3856%$56

       

      Now I want to create line chart for each product series. I want to create filter which has values like (Sale in % and Sale in $)

      based on filter selection Product series get rendered and I should be able to show my Y-Axis in Sales (%) and Sale ($ M) based on filter selection.

       

      Any idea or suggestion, how can I do this?

       

      Attached is sample worksheet for the reference of the data.