I have data in Excel that is listed by Date with a value against each date.
I wish to chart this data so that the Date is forced to be an X-axis "category" rather than a "value", that is, I want equal spaces between the dates along the x-axis of my chart rather than have the space between my data dates separated by the number of days between the dates.
I'm using a Scatter chart with the X-axis categories selected using named ranges defined by an OFFSET()MATCH() formula and with the Y-axis values named range defined using an OFFSET() formula that references the X-axis named range.
In the early versions of Excel (ie ,2007) dates for be explicitly defined as values, categories or time values, but I haven't been able to locate a corresponding command dialogue in Excel 2010.
Any clues will be much appreciated.