We might need a better description, or even a sample spreadsheet uploaded to the forum. I cannot recreate the problem. When I apply a suitable "divide by 1000" format to a pivot chart, it formats correctly.
We might need a better description, or even a sample spreadsheet uploaded to the forum. I cannot recreate the problem. When I apply a suitable "divide by 1000" format to a pivot chart, it formats correctly.
Originally Posted by shg
Thank you so much for the reply!
I have modified your file a bit(pivotchartaxisformatexample.xlsx).
The pivot table has the number formatting I am after, but the chart labels doesn't. In the pivot table the numbers are divided by 1000, but when I try to do the same with the chart labels something strange happen.
I am using Excel 2013, btw.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks