| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Two lines on y-axis
I have dates that I am using in an Excel chart in the format mmm-yy and would
like mmm- to appear on one line and yy on a second line underneath mmm-. Is there a way I can do this? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Two lines on y-axis
Hi,
Yes you can use a custom number format. Double click axis and go to Number tab. You need to put a line break in between months and years so type mmm ALT+0010 yy Use the numeric keypad for the ALT+0010 part. If done correctly you will just see yy in the textbox. You may need to force the alignment of labels to horizontal if the chart decides to angle the labels. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Amy" wrote in message ... I have dates that I am using in an Excel chart in the format mmm-yy and would like mmm- to appear on one line and yy on a second line underneath mmm-. Is there a way I can do this? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Two lines on y-axis
Thanks Andy - worked a treat!
"Andy Pope" wrote: Hi, Yes you can use a custom number format. Double click axis and go to Number tab. You need to put a line break in between months and years so type mmm ALT+0010 yy Use the numeric keypad for the ALT+0010 part. If done correctly you will just see yy in the textbox. You may need to force the alignment of labels to horizontal if the chart decides to angle the labels. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Amy" wrote in message ... I have dates that I am using in an Excel chart in the format mmm-yy and would like mmm- to appear on one line and yy on a second line underneath mmm-. Is there a way I can do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lines on x-axis | Charts and Charting in Excel | |||
| Force bar chart x-axis labels to two lines? | Charts and Charting in Excel | |||
| How do I specify using lines or bars on graphs w/ 2nd value axis? | Charts and Charting in Excel | |||
| lines on 2 axis | Charts and Charting in Excel | |||
| Missing lines in chart w/x-axis with months 1-24... | Charts and Charting in Excel | |||
Linear Mode
