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?
In order to solve the issue more effective, I need to clarify some information.
1. What formula are you use in the chart?
2. Could your post the dataset with sample data and the detail information about your chart design?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.