Hello,
I have some Pivot tables and charts linked to monthly results. The charts and slicers are displayed in chronological order: Jan - Dec (Format is 'general')
My issue is when third parties use the Excel the same graphs / charts / slicer are in alphabetical order i.e. Apr - Sep
I think that the issue may be due their language settings (French & German) however cannot find a solution
Any help would be most appreciated. Thanks,
You could convert them to numbers
Jan - 1
Feb - 2
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
and in addition to the solution of mikeTron (in #2)
format the cell (last option in the format drop box) and type 00 (zero/zero)
Please Login or Register to view this content.
In that case the months will line up according to the months.
Otherwise you get 1, 11, 12, 2, 3, 4
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Ahh, yes you are correct... long day
No problem, glad I could help.
Worked a treat! Many thanks to you both
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks