Good morning, the attached file shows total quantity and time stacked for two shifts to measure productivity. I, for the life of me, could not figure out how to display the month on both charts' horizontal axis's - I tried selecting data, but the Horizontal Axis Labels display Jan, Feb... rather than 1,2,3... - I tried formatting the x axis and change number format but did not have too much luck neither.
Please advise on what I am doing wrong? Thanks!
What do you want them to display, if not the month name?Originally Posted by namy77
Don
Please remember to mark your thread 'Solved' when appropriate.
Right-click on the horizontal axis > Select Data > Click on each one of your series to see which ones are showing 1,2,3,... instead of the month names.
Change those numbers to the month names then the chart will show the months instead of the numbers.
Ah - that works - I found the issue. Thanks!
Glad to help.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks