XL Reporter and Excel Charts
I have a report definition which reports the stock on hand in each warehouse, at the end of each month for the previous 12 months. It uses expanding rows for the warehouses.
I want to chart this with each warehouse as a series showing the trend by warehouse over the last 12 months.
I can't seem to get the chart to work, as it won't expand the number of series when the report generates.