3 Replies Latest reply: May 20, 2015 8:19 AM by Heidi Korhonen RSS

    Two values for same date/year not showing in bar chart

      Hi community!

       

      I have an excel file that has estimate and actual values and sometimes both for the same day (2014) and when I create a bar chart that year with both values is not showing at all! How can I tell, already in the load phase, to load only the latter value (6,95 in this case)? Or to tell the chart which value to use?

        Date                    Value

      31.12.20169
      31.12.20158,1
      31.12.20148
      31.12.20146,95
      31.12.20137,54
      31.12.20127,83
      31.12.20118,2
      31.12.2010

      8,51

       

      Thanks for your help!

       

      Heidi