View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Sirritys
 
Posts: n/a
Default I can't get Axis labels as I want!

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 ?