Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

ON the x-axis of a chart in Excel I would like to show the separates when years change and put the year in the middle of the interval.

How can I do that?

See the below image for an example of what I want to achieve.

share|improve this question
If I could add a few month as well would be nice! – Damian Oct 15 '12 at 12:54
up vote 2 down vote accepted

Not sure how your data is laid out, but you can do this by putting the year in its own column.

enter image description here

Then select the month and year as the axis labels.

enter image description here

Source: Show Months & Years in Charts without Cluttering

share|improve this answer

Format years as dates in source. For horizontal axis use Years for Major unit and Months for Minor unit. Format Axis Number as something like " | "yyyy may be about as close as Excel will get you, without say overlaying a text box with the desired layout:

SU487955 example

share|improve this answer
This does not work in Excel 2007. I am installing Office 2010 now! – Damian Oct 15 '12 at 15:17
It was created in Excel 2007! Though if you can live with the Values showing also (slightly misaligned), then maybe switch to show Data Table instead? – pnuts Oct 15 '12 at 15:21

The above didn't work for me, because I didn't want to show the months/weeks/days.

Therefore I added a layer only containing "|" and got rid of the tick marks from Excel by selecting the "None" option for both the tick mark types in the "Axis Options" of the Format Axis menu, and the "No line in the Line Color option. You can improve the example by setting the "the label distance to axis" to 1 under the "Axis Options".


share|improve this answer
The answers move around. Which one was "above" when you wrote this? :) – Ƭᴇcʜιᴇ007 Jul 16 '13 at 17:58

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.