Realize you have to add a series, then change its type. Start by using the
column data to create a column chart. Then add the X and Y data for the XY
series, which Excel at first adds as a column chart, and it usually looks
awful. Select the added series, and use Chart Type on the Chart menu to
change it to an XY type.

If you want variable width columns, there's more work involved, but it's
certainly possible:

http://peltiertech.com/Excel/ChartsH...thColumns.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"David" wrote in message
...
Is it possible to produce and combination scatter / column graph with
*different* numbers of data points in each series?

It's kind of hard to explain what I mean, but imagine beng able to have
one
of the series on a plane scatter graph drawn as rectangles from the x-axis
to
the point and being able to specify the width of these rectangles as an
absolute number.

Whenever I try to set a series with many points in it to scatter and a
series wth only a few points in it to column, Excel produces garbage. It
seems to want to use a column graph sort of x-axis, not a scatter plot
sort
of x-axis.

If you have octave (or maybe matlab) lying around, this is the sort of
thing
I mean:

octave:1 x1=-3.5:0.1:3.5;
octave:2 y1=normal_pdf(x1);
octave:3 x2=-3:0.5:3;
octave:4 y2=normal_pdf(x2);
octave:5 [x2 y2]=bar(x2, y2);
octave:6 plot(x1, y1, x2, y2)


cheers

dc