• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Chart Axis format

Afarag

Member
Dears,

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"

Gratefully,
 

Attachments

  • Copy of chart .xlsx
    54.8 KB · Views: 8
Hi Afarag..

Really confusing..

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..

BTW.. HAPPY BIRTHDAY.. :)
 

Attachments

  • Pivot Chart.xlsx
    18.6 KB · Views: 3
Hi Debrag,

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 :cool:
- 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 :)

Gratefully,
 
Back
Top