Creating line graph with one list where locations change

[Patrick Niedermeyer]

I can't recall what trick I used in the past to have Excel automatically recognize that a location has changed in a list such that Excel create another series on the same graph. Example data below. It should be a simple value vs. time for each location.

MW-1	1/1/2023​	100​
MW-1	2/1/2023​	175​
MW-1	3/1/2023​	300​
MW-1	4/1/2023​	500​
MW-1	5/1/2023​	150​
MW-2	1/1/2023​	10​
MW-2	2/1/2023​	20​
MW-2	3/1/2023​	46​
MW-2	4/1/2023​	50​
MW-2	5/1/2023​	20​
MW-3	1/1/2023​	80​
MW-3	2/1/2023​	175​
MW-3	3/1/2023​	250​
MW-3	4/1/2023​	500​
MW-3	5/1/2023​	225​

 

[awoohaw]

Is this data in a TABLE or Simply a list (I am thinking it is just a list).

By using a Table the underlying data for the pivot tables and charts can be refreshed easily.

The first image is your data, converted into a table, pivoted, and charted.

The second is a new row entered on the table and data refreshed.