X-Axis Quarter End Date Label formating issue


  • I am using Date as X-axis lable in a chart. My Min and Max value is formula using Col1. Col1 has all Quarter End Date. When i use formula for Date, Chart considering a first day of the next quarter instead of Quarter End Date.

    I am using MM-YYYY format for X-axis labels. But Chart is displaying labels as (Jan-YYYY, Apr-YYYY, Jul-YYYY,Oct-YYYY) instead of (Mar-YYYY, Jun-YYYY, Sep-YYYY, Dec-YYYY).  Is there any workaround to resolve this issue?

    Monday, October 28, 2013 6:25 PM

All replies