Dynamic x axis??

[KiKi]

I have a pivot table which pulls data from query and has data of all months. When i plot graph on that table then it has x-axis as months as 1, 2, 3, 4...12 in static format. I want to make this axis dynamic and want to show my current month as first month on the axis. Like Jun should be first month on axis...so x-axis should have 6, 7, 8...12, 1...5...

is there any way to do this? or i need to write macro?

 

[Hui]

Can you attach a sample file?

 

[Rozy Rahmani]

I want to pivot table video because i have only basic knowledge in pivot table but i want to expert in pivot so please help me everyone.

 

[Hui]

Rozy

Firstly Welcome to the Chandoo.org forums

Secondly please start a new conversation for your questions
This makes it simpler to search and follow a thread

In regards to your question goto: http://chandoo.org/wp/

 

[KiKi]

Can you attach a sample file?

Attached is the file. and I want to do below:

Current week is of Jun so Jun should appear in the end of the table so table should be started from Jul to Jun e.g. Jul, Aug, Sept, Oct, Nov, DEC, Jan, FEB, Mar, Apr, May, JUn.

 

[KiKi]

any help??

 

[Hui]

I'm really not sure how the data you supplied matches your question as it is neither a source or a Pivot Table

In a Pivot Table you can manually drag Column or Row headers to new positions