Hi all

I need to create a chart that charts the measured values of all items in a table. Each individual item needs to have it's own line over the date range. I want to be able to add items to the bottom of this table and have it automatically update the chart.

I have to manually edit the Series each time there's an addition and they have to be sorted by the Item Name (TP).

I'm certain there must be a way to do it!

Hope this makes sense.

Sample.xlsx

Thank you!