14 Replies Latest reply: Dec 17, 2015 9:06 AM by Marcus Sommer RSS

    Creation of Line chart

    Andrew Thomas

      Hi

       

      I'm having difficulty creating a line chart with my data.

       

      I have the following twelve fields that have a value and each field relates to a month ( See Below)

       

      WOG001 = £100

      WOG002 = £150

      WOG003 = £300

       

      And so on through to 012

       

      I want to create a line chart that accumulates the fields for each period

       

      Period 1 = WOG001 = £100

      Period 2 = WOG001 + WOG002 = £200

       

      And so on

       

      At the moment the data set does not contain a year or period field and I'm having trouble working out how I can create a line chart that has year and period on the horizontal and value as the vertical. The fields above only contain a value and it is the field itself that defines that it relates to a particular period.