Does one record in lineitems record the use of x amount of a single material?
If so, a bar chart based on the line items table with the appropriate options, including a summary field for the length of the bar and these two options:
Use Data From Current Found Set.
Show data points for groups of records when sorted.
You then sort your records by either product or material ID to get one bar for each type of material and then perform a find to limit the records used for the chart to the specified date range or other criteria you choose to specify.
Yes it does - each article has a weight and a material type and that is recorded in the line items as a calculation field.
So these are the settings for the table in the imaged attached:
(Arrgh sorry with the Google thing I thought that it was one extension now I'm not so sure)
And this is the table - it's quite an uneven distribution and lord knows what those figures ae doing... maybe I've not connected the materials and the products table correctly?
OK Silly billy me - Material type goes along the X axis not the Y. Still not sure that I'm seeing what I expect but it's much closer to what it should be...
The Y axis needs to be a summary field--not a calculation field and you need to sort the records to group them by material type.
Got it I think: