2 Replies Latest reply on Sep 14, 2012 1:46 PM by mahabir.bhandari

    How to show individual values while creating Bin chart

    mahabir.bhandari

      HI,

      I am trying to plot temperature vs energy data in 2 deg temp bin. I can plot the sum or average for each bin. I was wondering if it is possible to plot the values  individuality.  For example, if I have the following data:

       

      Temp F     Energy (kWh)

      68.1          20

      69.0          25

      69.9          30

      80.1          60

      80.7          70...

       

      If I plot bin diagram, I can get one  bar with 75 kWh (sum) for a bin 68-70. I would like show all 3 values (three thin bars of 20, 25 and 30) for  bin 68-70. Is it possible and if yes, how can I do it? I appreciate any help/tips.

       

      thanks,

      Mahabir