HEK wrote:
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


Sorry for being unclear. I'll try to make more sense now.

I'm not compromising the table structure. It has to stay the way I
posted it. No I'm plotting one curve from the table values so that I
get one curve plotting values from 2002 Q1 to 2006 Q1.

Plotting is fine but I don't know how to get right labels to X-axis. In
other words, what should I but to "Source Data - Category (x) axis
labels".

I can do it with
"=companyname!$B$38;companyname!$A$40:$A$42;compan yname!$C$38;companyname!$A$40:$A$42;companyname!$D $38;companyname!$A$40:$A$42;companyname!$E$38;comp anyname!$A$40:$A$42;companyname!$F$38;companyname! $A$40:$A$42;companyname!$G$38"

But there has to be easier way, right ?

Here is table with column and row numbers:

A B C D E F G
38 2002 2003 2004 2005 2006 2007
39 Q1 100,00 100,00 100,00 98,95 102,79
40 Q2 100,00 100,00 99,65 99,01
41 Q3 100,00 100,00 98,84 99,01
42 Q4 100,00 100,00 98,23 99,00