Fixing 1905 default in excel axis graphs (yyyy)

February 18, 2013 at 09:08:12
Specs: Windows 7
I've seen many good helpful suggestions to get excel to stop defaulting to 1905 when trying to graph years (yyyy) on an excel sheet. However, I have found that if you simply want to use the year as an axis line in a chart, the quickest bandaid approach is to not even fight the formatting (yyyy).

Just insert your graph without selecting any information for your date axis. Once the chart is up, just right click on the axis of the graph, choose the "select data" window, and then reassign data to the axis.

If you want your year column or row to be in the Y axis place your year data in the the "Chart data range" and click OK. If you want it in the x axis, choose the "edit" button under the Horizontal category Axis label section and assign it your year information from your spreadsheet there.

See More: Fixing 1905 default in excel axis graphs (yyyy)

Report •

February 18, 2013 at 10:20:57
Thanks for the suggestion. I will keep it in mind.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question