I'm constructing a very simple pivot chart where data begins in April and finishes in March ie a financial year.
My rows of dates are grouped by month but in my chart I see along the bottom axis the months begin at January and end at December, whereas I want the chart to begin at April and end in March the following year.
How do I resolve this?
Many thanks
Bookmarks