Forum Discussion
Displaying data from SharePoint list into a simple bar chart
Hi Tom898
Your data source needs to be transformed so each column name after Date becomes a category with another column corresponding its values. That would be something like
Sort 6
Sort 4
Sort 8
Store 6
Store 10
Store 6
In order to do that, go the query editor, select the first three columns, go to transform and select unpivot. You can rename the generated columns called attribute and value as desired. Those 7s'es should now be in one column with their corresponding values in the next column.
Below is just a sample of what unpivot does. Just ignore the data as it doesn't make sense to unpivot it
When I put the unpivoted data in the chart, all the 7s catagories are shwoing as the same value, despite them all having different ones. Do you know why this may be?