6 Replies Latest reply: Jun 27, 2016 8:13 AM by Steve Br. RSS

    Creating range

    Steve Br.

      Hello!

       

      I would like to create a line chart using the sample data beneath. I need to aggregate the kilograms into three groups: 0-3000, 3001-6000, 6001-9000 so that the chart shows the following information:

       

      y-axis: costs per ton

      x-axis: month

      lines: cost development for each group

      legend: carriers

       

      I don't know how to create these three groups using the given ranges. Would appreciate any help. Thanks!

       

       

       

       

       

      CarrierKGCostDate
      Carrier 138361421-03-16
      Carrier 115901520-02-16
      Carrier 124031606-01-16
      Carrier 18341916-03-16
      Carrier 17231526-03-16
      Carrier 156101425-03-16
      Carrier 154561430-01-16
      Carrier 18286605-01-16
      Carrier 115691919-02-16
      Carrier 16925615-02-16
      Carrier 120111511-01-16
      Carrier 16545719-03-16
      Carrier 119941719-01-16
      Carrier 137961515-01-16
      Carrier 125811618-03-16
      Carrier 117471815-02-16
      Carrier 159761122-01-16
      Carrier 155451511-01-16
      Carrier 120742026-03-16
      Carrier 18685931-03-16
      Carrier 187941002-03-16
      Carrier 116041717-01-16
      Carrier 16661525-02-16
      Carrier 16846720-01-16
      Carrier 135401312-03-16
      Carrier 142061218-02-16
      Carrier 133601407-01-16
      Carrier 115901928-03-16
      Carrier 138851022-02-16
      Carrier 126911606-02-16
      Carrier 256881218-01-16
      Carrier 210221915-03-16
      Carrier 26651525-03-16
      Carrier 220231915-02-16
      Carrier 230851425-01-16
      Carrier 250431304-01-16
      Carrier 231251031-03-16
      Carrier 241091321-01-16
      Carrier 258441511-02-16
      Carrier 240641030-01-16
      Carrier 222911708-02-16
      Carrier 27829601-02-16
      Carrier 26804701-02-16
      Carrier 235401424-03-16
      Carrier 28161809-01-16
      Carrier 26486610-01-16
      Carrier 253481126-03-16
      Carrier 28914707-03-16
      Carrier 248631215-03-16
      Carrier 242271006-02-16
      Carrier 221141605-02-16
      Carrier 250281430-03-16
      Carrier 231731117-03-16
      Carrier 223821609-03-16
      Carrier 210212005-01-16
      Carrier 26096501-03-16
      Carrier 28820928-01-16
      Carrier 258161207-02-16
      Carrier 237371026-02-16
      Carrier 28369626-01-16