Hi Everyone,

This may be a long shot but:

I have data containing an item IDs, and then Lat/lon coordinates of the items over time,

It's all in one list as the data arrives

I basically want to create a chart that has each Item ID in it's own series, without having to sort the data by item ID and adjust all of the series data ranges each day and plot the lat/lon coordinates as an x-y graph (map)

I was thinking I could somehow do it with named ranges and a sumproduct type arrangement, but have got a bit stuck.

I've got ten individual item IDs that won't change.

I hope that makes sense.

If you need to know anything else please ask.

My alternative will be to write a macro to sort the data into another worksheet by item ID and having fixed ranges in the chart.