Home |
Search |
Today's Posts |
#1
|
|||
|
|||
X-axis in months?
How do I get the x-axis on a graph to display the text Jan-Dec rather than
the numbers 1-12? |
#2
|
|||
|
|||
Hi Peter,
Create you xy scatter chart. Use the source data dialog to add another data series. The data series requires 12 values. Select the new series and move to the secondary axis. Now change its chart type to column. Use the source data dialog again to specify the category label range. Remove the tick labels from the main x axis. Use Chart options to display the secondary x axis. You should now have the month names at the top of the chart. Double click secondary xaxis and check on the scale tab, Value (Y) axis crosses between categories. Double click secondary yaxis and on the scale tab uncheck Category(X) axis crosses at maximum value. You can now delete the secondary yaxis. Format the columns to have no border and fill. Or you could use a dummy data series to create you own xaxis labels. See Jon's examples of arbitrary axis scales to get an idea. http://peltiertech.com/Excel/Charts/axes.html#ArbAxis Cheers Andy Peter wrote: How do I get the x-axis on a graph to display the text Jan-Dec rather than the numbers 1-12? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
If you put the months in your spreadsheet as dates e.g. 1/1/05, 1/2/05,
1/3/05, etc and format them using custom format as mmm then they will display as Jan, Feb, etc but the underlying data will be numeric. You can now create an XY scatter graph and format the x-axis using the Custom number format and mmm. You will have to fiddle around with the scale section to get the display to start at Jan and end at Dec e.g. enter 38353 to start at Jan 2005 and 38718 to end at Dec 05, and set the major and minor tick marks to be 30 apart so you get a label for every month. Andrea Jones www.stratatraining.co.uk Peter wrote: How do I get the x-axis on a graph to display the text Jan-Dec rather than the numbers 1-12? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change axis info on radar charts | Charts and Charting in Excel | |||
space between y axis and data points.. | Charts and Charting in Excel | |||
How do I set permanent secondary axis in PivotTable chart? | Charts and Charting in Excel | |||
Second X axis at top of chart? | Charts and Charting in Excel | |||
Labels on Chart with Negative Value Axis | Charts and Charting in Excel |