i have a pivot table data with date format "Mar-12", but this date in chart appear in format "03/01/2014"
i ask to get the chart axis date format to be "Mar-12"
You have cretaed a lots of puzzle for me..
* Where is the "pivot table 1"!!!
* Why all those name are created dynamically..!!
* Why Pivot Table 1 is in cache but not in any sheet..
but who cares..
With your provided data, I created Pivot as well as Pivot Chart..
I change the format... in Pivot Number Format.. and its working fine for me..
thanks a lot for your follow up and get my issue handled,
- the 1st pivot behind the chart
- all this data for a test to get more analysis after that to manager
- but what about of the chart axis format i use office 365 proplus and try to change the format to date but always turn back in general mode
-thanks a lot for your kind word appreciate that tooooooo much