Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Scatter Column chart ? | Charts and Charting in Excel | |||
How do I add column A data labels to a scatter of columns B and C? | Charts and Charting in Excel | |||
Time axis column and scatter/line graph | Charts and Charting in Excel | |||
help with a scatter graph of conditioned values | Charts and Charting in Excel | |||
Copying the contents of a column into a chart | Excel Worksheet Functions |