7 Replies Latest reply: Jul 6, 2017 10:34 AM by Anand Gangwar RSS

    How can I add Column names of data (from which a chart is created) as items of list box.

    Anand Gangwar

      Hi Everyone,

       

      Got terribly stuck with a situation. I have a data-set in excel in the following format:

           

      DateCoalHydroSolarWind
      1-Jan-17130250336404
      1-Feb-17128219327423
      1-Mar-17156287375454
      1-Apr-17133253389452
      1-May-17171253305469
      1-Jun-17138251347430
      1-Jul-17191279312474

       

      I have created a stacked Bar chart out of this data, with each field (i.e. Coal, Hydro, Solar & Wind) appearing in different colors. Now I would like to have a list box with all these 4 field names. And once, I select a particular fueltype, the bar chart only displays data for that particular fuel. Thanks a ton for your help in advance.