In the attached workbook, I have created a chart which shows a value of a data series based on which day of the year the data series occurs.
I am trying to make the X axis say "Jan" for days 1-30, "Feb" for days 30-60, "Mar" for days 60-90, but I'm at a bit of a hangup. I can't figure out how to make the chart axis be a calculated field "TextDate". Any ideas?
One workaround that may work is to add reference lines for each month as a constant value. Effectively this will give you a line identifying each change in month and you are able to label each line with the month. For example you could add a reference line with a value of 30 and label it as Jan or Feb - whichever you think is more appropriate.