Displaying month-to-month trends using the qChartView web part for SharePoint 2010 - SharePoint Customization - SharePoint for All - Dell Community

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

This question has been answered by kenny.wu-quest
SampleSPChart.pdf

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?

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

Sales
Category Jun 15 Jul 15  Aug 15 
Location 1 6 4 3
Location 2 8 5 5
Location 3 3 2 6

Verified Answer
  • Hi edwinnieves,

    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.

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

    Data

    Group

    Month

    26

    3001 – Location 1

    Jun 15

    9

    3002 – Location 2

    Jun 15

    4

    3003 – Location 3

    Jun15

    3

    3004 – Location 4

    Jun 15

    20

    3001 – Location 1

    Jul 15

    3

    3002 – Location 2

    Jul 15

    6

    3001 – Location 1

    15-Dec

    2

    3002 – Location 2

    15-Dec

    25

    3003 – Location 3

    15-Dec

    4

    3004 – Location 4

    15-Dec

     

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

     

    Kenny.

All Replies
  • Hi edwinnieves,

    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.

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

    Data

    Group

    Month

    26

    3001 – Location 1

    Jun 15

    9

    3002 – Location 2

    Jun 15

    4

    3003 – Location 3

    Jun15

    3

    3004 – Location 4

    Jun 15

    20

    3001 – Location 1

    Jul 15

    3

    3002 – Location 2

    Jul 15

    6

    3001 – Location 1

    15-Dec

    2

    3002 – Location 2

    15-Dec

    25

    3003 – Location 3

    15-Dec

    4

    3004 – Location 4

    15-Dec

     

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

     

    Kenny.

  • 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:

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