I have a chart in which I want to abbreviate that the months along the x-axis. Right now the values are January, February, March, etc. I want the value to read Jan, Feb, Mar, etc.
The source data/table reads as January, February, March, etc., which I want to remain as is (i.e. I don't want to change data table to Jan, Feb, Mar, etc).
Is there a way to change the x-axis to 3-letter format desired. I tried to format the cells using custom format to "mm", but that didn't work. Thanks
Last edited by maacmaac; 04-06-2010 at 12:47 PM.
Hi,
Have you tried to double-click on your axis and format month values from within the chart ?
HTH
I had tried that and just figured out why I couldn't get it to work. The data tables had the dates formatted as general, not as dates. Once I fixed that part, the other part also worked. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks