On my chart the X-Values show up as 12345… I want to change the X-Axis to read 2009 2010 2011 , I can’t seem to figure out how to do this.
I’ve had something similar in Calc. iirc Format dates then chart it. Might need display as formatted.
I have had similar problems, but with actual dates to be displayed. Your case should be easier to solve, displaying only the years which could be treated as numbers. If your first column of data is the values of years, then it should display as a number. You didn’t say which version of Calc you are using. Can you give us a small sample of your data so we can “play” with it and figure out a solution?