Hi,
I am trying to create a scatter chart with dates as the x values. I need to have the x axis values displayed on the x axis be simply year, but the data points themselves need to reflect the specific date, i.e. if a data point relates to June 5th 2010 I need the point to appear between the ticks on the x axis for 2010 and 2011. Currently I'm only able to get the data points to line up on the year ticks and I'm not able to get the x axis to show the right year. I have attached two files - one very basic Excel file and one drawing of what I am trying to do. I know this must be so simple but I can't figure it out! I can't find any place to change the axis type to Date. Any help is greatly appreciated!
Bookmarks