X axis does not show Years from data
Simple graph to show Garden Yield (P&L) and other data for each year. Regardless of what the 2009-2014 columns are formatted as the X- axis on the graph does to change to reflect data even after formatting X axis to Automatically Based On Data.
I need the X axis to read 2009-2014 and so on.
Tried Formatting 'Year Data' as yyyy under 'special' but this just altered the secondary 'Y' axis to the rhs.
Earlier versions of Excel did not have this problem nor does Works Spreadsheet.
Please advise.
|