Skip to main content

I haven't been able to figure out how to make the dates show up MMM YYYY on any of my charts. Is there an easy fix (workbook attached)?

답변 2개
  1. 2017년 3월 28일 오후 9:00

    Hi James/Deepak:

     

    Once you select "More-Custom' from which your MY date function is coming from, we can't format the date as the format is automatic:

    Hi James/Deepak: Once you select

    The way around will be to select "Month(Date)" as shown below, which then allows you to format the axis date as explained by Deepak:

    pastedImage_4.png

    pastedImage_7.png

     

    Thanks,

    PN

0/9000