Not confusing. The problem is that for Line, Column, Bar, and Area type
charts, Excel uses the categories of the first series for all of the
series of that axis group. The way you could try to make it work in
your case is to provide blank cells in one series where only the other
series has data. Like this:

Series 1 Series 2
1983 50
1985 60
1987 71
1989 81
1993 90
1995 101
1997 108
1999 118
2000 124 137
2001 152
2003 168

If you want to make interesting box plots, by the way, I have a page on
my web site that shows how to do nicer ones than just a Hi-Lo-Close type
of chart:

http://www.geocities.com/jonpeltier/...tml#BoxWhisker

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

gomirage wrote:
Ge guys,

I tried hard but the same problem. What i am trying to do is a boxplot
with the first set of data following this procedu

- Highlight the whole table, including figures and series labels, then
click on the Chart Wizard.
- Select a Line Chart.
- At Step 2 plot by Rows, (the default is Columns), then Finish.
- Select each data series in turn and use Format Data Series to remove
the connecting lines.
- Select any of the data series and Format Data Series; select the
Options tab and switch on the checkboxes for High-Low lines and Up-Down
bars.

But when finish the box plot it moves automaticaly to the first data
(1983) or to 2000. In the first case the space is to much and in the
second case the first data of the second series (2000) is hiden.

I hope this no really confusing