Cleaning up horizontal axis labels automatically

[BKGLTS]

Hello,

I need to clean this chart up so it only shows each month/year on the horizontal axis one time.
The data range I am using as the horizontal axis labels is W14:DUR14.
Each cell in this row has the Month/Year in sequential order, but lots of duplicates.
The line data in the chart is on row 13 directly above the label range data.

The label data is sort of like this:

W14=Aug 2018
X14=Aug 2018
Y14=Aug 2018
Z14=Sep 2018
AA14=Sep 2018
AB14=Sep 2018
AC14=Oct 2018
AD14=Oct 2018
AE14=Oct 2018
and so on...

The result looks like this:​

I was thinking maybe I need to create another row with a formula that does this somehow, but was hoping the chart has a functionality to customize this.
This range is based on formulas so the dates will constantly be changing and the range of months/years shown will vary.
So, the solution needs to work with that.

Thank you!
B​

 

[Jon Peltier]

Charts don't do that kind of thing by themselves, but a simple formula, like this in cell W15 will make X values that work the way you want:

=IF(W14<>V14,W14,"")

 

[BKGLTS]

Thank you Jon.

I ended up doing something similar without creating a new row.
I just put the following in front of the formula in row 14:
=IF(CONCATENATE(TEXT(X$15,"mmm"),TEXT(X$15," yy"))=CONCATENATE(TEXT(W$15,"mmm"),TEXT(W$15," yy")),"",IF...…..