I would like to create a chart based on two column values in a SharePoint list (Title column can be used as a filter):
Title: Entry 1
Produce: Apples; Oranges; Bananas
Quantity: 10; 8; 14
I would like a bar chart that has Apples, Oranges & Bananas on the X Axis and the quantity values on the Y axis. If there is a simple way to do this then one could easily use a "merged" data column as produced by MS InfoPath.