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

So, if I understand, you data looks like:

2008/01/01 1234 (January data)
2008/02/01 5678 (February data)
2008/03/01 9023 (March data)
etc.

And you can't get the labels of the chart to show Jan, Feb, Mar, etc. but
instead are showing something like:

2008/01/01
2008/02/01
etc.

The chart will use the date format shown in your spreadsheet, so if you
format the column of dates appropriately your chart will update to that
format. Of course, if your dates are in Days, you would need to update the
Axis scale to be Months (if you just want to show Jan, Feb, Mar).

"John1791" wrote:

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.