I compiled a table, using this application, including data I gleaned from a book titled Ride the Big Red Cars, about the old PE system that once flourished in the Los Angeles area (see More of the Straight Dope for Cecil’s comments on this); the book included financial records for the period from 1912, when the PE first issued a separate statement (It was owned by the Southern Pacific Railroad) until 1953, when the remaining Red Car lines were taken over by Metropolitan Coach Lines.
Anyway, when I compiled a chart from the table, I wanted the numbers along the bottom (the x-axis, apparently) to show the years. Instead the sequence of numbers in the x-axis begins at 1–first year, apparently–and goes as far as 41st year (1, 4, 7, etc.). How do I get it to replace those single numbers with the year numbers, which I had keyed in at the top of the columns? 
Thanks very much.
When you create a chart, choose “custom.” The initial dialogue box should have two tabs, one labelled “sequences” (or something like that). At the bottom of this tab you can select a row or column from the table as the labels for the major axis.
Hope this helps.
You should also be able to right click on the chart and choose “Source Data”. You will be able to specify a cell range as the source of the X and/or y axes.
Yes, you can do that, but that only affects the data points in the graph, not the labels of the axes.
Thanks to both; I’ll try it.
Dougie_monty 