Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
chart to SUM mileage over months | Charts and Charting in Excel | |||
Dynamic 12 months data on the chart | New Users to Excel | |||
Last 12 months chart | Charts and Charting in Excel | |||
Chart comparing months between 2 years | Charts and Charting in Excel | |||
Chart help Hide Months | Charts and Charting in Excel |