LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Scatter Column chart ? Euh Charts and Charting in Excel 8 October 24th 05 11:15 PM
How do I add column A data labels to a scatter of columns B and C? Christina1 Charts and Charting in Excel 3 March 27th 05 03:43 AM
Time axis column and scatter/line graph kraymond Charts and Charting in Excel 5 February 8th 05 11:34 PM
help with a scatter graph of conditioned values uriel78 Charts and Charting in Excel 3 February 2nd 05 06:01 AM
Copying the contents of a column into a chart Richard Excel Worksheet Functions 1 November 16th 04 02:39 PM


All times are GMT +1. The time now is 06:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"