Dynamic Ranges in Charts

[Llenni]

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!

[Andy Pope]

a chart is not clever enough to create new series based on content of column.
and the way you have the chart at the moment the data points are incorrect.

you could use a pivot table/chart to build separate series. You would need to refresh pivot table when new data points are added to data table.

[Llenni]

Thanks Andy

Can't believe I uploaded it with the chart showing the wrong information! Rushing too much.

I'll have a look and see if this will work for what I want.

I appreciate the your reply, thank you.

Llenni