Microsoft Excel Horizontal Axis with a Bar graph help?

I am trying to put the year 1911 to 2008, without manually inputing every year. Any suggestions?|||Put the year "1911" in column A1 (for example) then in B1 type "=SUM(A1+1)" select the cell B1 with the "+" in the corner and drag it across the page|||One way is to enter 1911 in your first column and then 1912 in the next. Then grab the repeat handle - bottom right corner of the 1912 cell and drag to the right.





I use this method to set rows but it works fine for columns too.





Edit: Excell calls it (the bottom right corner of a cell) the fill handle.