Guys,

I have been working a series of chart and I recently I stumble upon a chart that saves some space on the month and year; Months will start with the first letter and the year will show only one time under the letters of each month.

Trying to apply this to my reality was a little bit more complicated than I expected, since I canīt manage to have Year and Month to be dynamic along with rest of the data.

Does anyone here have clue to set a dynamic named range for the XValues to accommodate this? My chart uses the last 12 months and the formula is pretty simple:

Formula: copy to clipboard 
=OFFSET(MyDashData!$A$1;COUNTA(MyDashData!$A:$A)-1;3;-MIN(chtLen;COUNTA(MyDashData!$A:$A)-1);1)



This is the chart example that I intend to use:
Chart_Month_Year.JPG

Appreciate all help!
CariocaExcel