Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all
in my model i have a bar chart -
i want to change the dim value titles, i.e instead of 2019/Q1 -> '19-Q1'
any ideas ?
advanced thanks
=mid([Year Quarter],3,2) & '-' & right([Year Quarter],2)
my sample:
=mid('2019/Q1',3,2) & '-' & right('2019/Q1',2)