Is it possible to get my line chart to show fiscal weeks instead of calendar weeks and still keep it in date format? I can do it if I convert to "Text" axis type, but for what I'm doing, I have to have it in "Date" axis type.
For example, my fiscal week ends on June 17th (Tue - Mon), but the date format is using June 15 (Sun - Sat)
I am not sure I understand what you are trying to do or what you have tried.
What happens if you fix the axis minimum to a Tuesday date (assuming that your base unit is days and your major unit is 7 days)? In my tests, the axis then has a tick mark for each Tuesday? Is that the effect you are looking for?
Originally Posted by shg
That worked!! Thank You!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks