Loading...

Displaying month-to-month trends using the qChartView web part for SharePoint 2010

Displaying month-to-month trends using the qChartView web part for SharePoint 2010

Home Forums QuickApps Forum Displaying month-to-month trends using the qChartView web part for SharePoint 2010

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • #7090
      Anonymous
      Anonymous
      Participant

      Hi

      n

      qChartView cannot generate this kind of chart base on this data. It cannot use the column as the axis data, it generates the chart base on the field’s value.

      n

      For example, if you want to generate the chart like your attachment, you need to provide the below list data:

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      Data

      n

      n

      Group

      n

      n

      Month

      n

      n

      26

      n

      n

      3001 – Location 1

      n

      n

      Jun 15

      n

      n

      9

      n

      n

      3002 – Location 2

      n

      n

      Jun 15

      n

      n

      4

      n

      n

      3003 – Location 3

      n

      n

      Jun15

      n

      n

      3

      n

      n

      3004 – Location 4

      n

      n

      Jun 15

      n

      n

      20

      n

      n

      3001 – Location 1

      n

      n

      Jul 15

      n

      n

      3

      n

      n

      3002 – Location 2

      n

      n

      Jul 15

      n

      n

      n

      n

      n

      n

      n

      n

      6

      n

      n

      3001 – Location 1

      n

      n

      15-Dec

      n

      n

      2

      n

      n

      3002 – Location 2

      n

      n

      15-Dec

      n

      n

      25

      n

      n

      3003 – Location 3

      n

      n

      15-Dec

      n

      n

      4

      n

      n

      3004 – Location 4

      n

      n

      15-Dec

      n

      n

       

      n

      In the qChartView, the x axis is “Month”, the data Series is “Data”, and you must set the “Filter Field Name” to “Gourp”

      n

       

      n

    • #4633
      Anonymous
      Anonymous
      Participant

      I am trying to generate a line chart using the qChartView web part for SharePoint 2010 to show month-by-month data for certain categories. The X axis will have dates (month / year) and the Y axis the categories. I am having no luck; can somebody help?

      n

      The SP2010 list looks like this. The chart and table are also in attachment:

      nSalesnCategorynJun 15nJul 15 nAug 15 nLocation 1n6n4n3nLocation 2n8n5n5nLocation 3n3n2n6n

    • #7093
      Anonymous
      Anonymous
      Participant

      Thanks! I transposed the position of the axes and I was able to make the chart. Not exaclty what I needed as I was using the List as lookup for another List; but at least I got it to work. The table now looks like this:

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      n

      Date Category 1 Category 2 Category 3
      Jun 2015 3 4 5
      Jul 2015 5 2 2
      Aug 2015 6 4 4

      n

Viewing 2 reply threads

You must be logged in to reply to this topic.