Im using Excel 2010 for MAC.
I have a stacked bar chart. The horizontal (value) axis consists of dates. They are in date format in the spreadsheet. On the chart I want the horizontal axis scale to be Dates. When I go to Format Axis the horizontal axis scale is Auto (numbers) and I can’t change it to Dates. The dates on the value axis are spread over 2 years. They do not display properly as numbers since months do not have same number of days.
Ive seen postings on this but none have taken me to a fix.
By: Brian Silverstein