I have three columns: id, year, data. How can I simply plot in Excel the time series of the values in data (i.e. data on the Y-axis and year on the X-axis), for each id? So for instance, if I have three different identifiers (i.e. three values for id), I will have three different time series on the same plot (one for each id).
It must be super easy but I'm not a big user of Excel,
Many thanks