Assuming that the original data is in column A, you can enter the formula =mod(year(A 1), 2) in B 1, and then drop it down to fill it in, and you can filter out 0 or 1 to represent even or odd years.

A line chart is data arranged in columns or rows of a worksheet and can be drawn as a line chart. Line charts can display continuous data that changes with time, so they are very suitable for displaying the trend of data at equal time intervals. In a line chart, category data are evenly distributed along the horizontal axis, and all numerical data are evenly distributed along the vertical axis.