View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Months in Excel Chart

format axisnumbercustommmm or mmmm

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"John1791" wrote in message
...
I have MS Excel 2007 and am trying to create a chart. My data is in two
columns, A is the twelve months of the year, and B column is numeric
values.
I wish to create a line chart that displays the numeric values across the
months (X-axis data labels) (January to December).

I can make the chart, but I can not get the months to show up on the
x-axis.
I do not wish for a Month-year label (I can do that), just the month text.
How do I do this? I can accept the months to be in the following format:
J,F, M, etc., Jan., Feb., March; January, February, March, etc.

Thank you in advance.