I have done this chart hundreds of times and never had this issue. Must be something that I am missing. I designate cells a2:a361 as my horizontal axis values and then b2:b361 for my series values. It repeats 1990 in the beginning even though 1990 appears 12 times in exactly the same fashion as the other years 1991 to 2019. the data set is attached. Is this something related to chart design (select data) or formatting the axis?
Bookmarks