I don't understand what you mean by "Excel doesn't seem to
understand that they are supposed to fit only every fourth value in the
line." Is it you want to show the four quarters repeatedly for each year, and
this group of quarters labeled for each year? Assuming that is, set up yr
sheet as follows.
In A1: 2002
In A2: Q1; in B2: Q2; in C2: Q3; in D2: Q4;
In A3:D3 the respective values for Q1:Q4
Repeat for 2003 in cells E1:H3, and repeat until you have all yr years
Now select A1:H3 (just to show the effect for two years; adjust your range
accordingly) and see whether you like what you get (it should display two
rows of axis lables: Quarters and below the year, the years separated by
vertical border lines).
HTH, Henk


"Sirritys" wrote:

I have table like this:

2002 2003 2004 2005 2006 2007
Q1 100,00 100,00 100,00 98,95 102,79
Q2 100,00 100,00 99,65 99,01
Q3 100,00 100,00 98,84 99,01
Q4 100,00 100,00 98,23 99,00

The problem is that when I chart the table I get into X-axis label
years 2002-2007 right after each other. Excel doesn't seem to
understand that they are supposed to fit only every fourth value in the
line.

So what I want to x-axis label is either this:
2002 Q2 Q3 Q4 2003 Q2 Q3 ...etc
OR
2002 2003 2004...etc

What excel gives me now is:
2002 2003 2004 ... etc

Anyone knows how to fix this ?