[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Author]

Posts