If you arrange your data appropriately, a stacked chart could be what
you need:

X Y Z
X1 Y1
Z1
X2 Y2
Z2
X3 Y3
Z3

The three series stack on each other, but where there are X and Y
values, there's no Z, and vice versa.

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



ALVESM wrote:

hi everyone. i have three series say X, Y and Z. however X only relates with
Y and Y only relates with X. together they relate with Z. i thought of
plotting this using a stacked column (with both X and Y) that goes alongside
a regular column (Z).
can this be done using excel 2000? is there a smarter way to plot this? tyvm