View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John1791 John1791 is offline
external usenet poster
 
Posts: 7
Default Months in Excel Chart

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.