Excel chart

Resolved · High Priority · Version 2016

Thu 26 Mar 2020, 10:08 Delegate Fay said...

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

Fri 27 Mar 2020, 13:31 Trainer Jens said...

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

Fri 3 Apr 2020: Automatically marked as resolved.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

The dual nature of toolbar buttons

Many toolbar buttons are dual purpose, though the two purposes are often linked in some way. For example, Align Left aligns a cell's contents to the left of the cell. However, hold down Shift and press the Align Left button: Excel aligns the cell contents to the right.
You may respond: So what? Well, you can reduce the number of buttons on your toolbar to make your screen less cluttered and allow more room for, perhaps, some of your own commands. After all, what's the point of an Align Right button when Shift+Align Left does the same thing?

View all Excel hints and tips