View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
David
 
Posts: n/a
Default combination x-y scatter and column graph

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