Special Reorder X-Axis Issue

[m5edward]

Hi Everyone,

My company's fiscal year runs from July 1 to June 30.

In the graph below you will see that this week's sales numbers are at the beginning of the x-axis, when it should obviously be at the end.

The green chart below is how my sales data is laid out.

Also, the graph is a pivotchart that is running off of a data model, if that matters.

Any suggestions on how to remedy this issue?

Thanks,

Mark

 

[BSALV]

this is your pivotchart ?
Group on years afterwards on months ?

 

[m5edward]

Thanks for the reply!

It was an issue with the format of my dates.