Stacking Charts in Excel

[Guest]

Hi,

I have asked a similar question before "how to stack charts in excel" and
someone very kindly pointed me towards the following web link:
"http://www.peltiertech.com/Excel/Charts/StackedCharts.html".
For stacking this sort of chart you need to have the same x-axis for each
data set that is staked.

Now, i'm wondering if it is possible to stack charts where each y-axis data
set has its own specific x-axis data. The overall range on the x-axis will
be the same, but the individual data points that will be plotted will vary in
location along the x-axis depending on which y-axis data set it is.

For example, the data required to be stacked may look like this

X1 Y1 X2 Y2 X3 Y3
0 8 0 7.3 0 7.7
0.2 7 0.15 6.9 0.22 7.1
0.4 6 0.45 6.1 0.42 5.9
0.6
0.8
1 0 1 0 1 0

And I would like to stack the plot for X1 vs Y1 over the plot for X2 vs Y2
which is over the plot of X3 vs Y3 etc.

Any help on this matter is greatly appreciated!

thanks =)

 

[Guest]

By default, Excel assumes that the same X series is used for each series, but
there's nothing forcing you to use that. You can use a different X-Y
combination for each series.

Create an XY plot of the first series of data.

Let's assume that the second series is in cells C110.

Select those cells and copy.

Select the chart and choose EDIT -> Paste Special
Add cells as new series
Values Y in columns
Series name in first row.
Categories X Values in FIrst column

And VIOLA (he he), you have it!

 

[Alvin Bruney [MVP - ASP.NET]]

one approach to d

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc

 

[Guest]

Thanks Barb for your reply! I can't stack these charts however. Is it
possible to select different series (x&y) and still stack the plots on top of
one another?

Thanks =)