Fay has attended:
Excel Advanced course
Excel chart
Hi!
In an Excel chart with dates on the x axis where the data format is mmm yyyy, how can you ensure that the label of the x axis show mmm and yyyy on 2 lines, one above the other?
Sometimes the yyyy text moves down to a second line by itself; sometimes the text stays on one line and crosses over the previous unit.
Many thanks,
Fay
RE: Excel chart
Hi Fay,
Thank you for the forum question.
You can force Excel to show the labels in two lines if is not date formatted YYYY MMMM.
If the months and years were text formatted you can place your courser in the source column between the month and the year and press Alt + Enter. Then you will get a line break in the source column and this will also give you a forced line break in the chart.
Otherwise you will need a column for the year and a column for the month.
It is not the best solution but unfortunately the only options.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
