multiple series from one column
 

Hi,
my data are organized in three columns: X, Y and a column with the series
names (say A, B and C). Is it possible to create a single XY plot for the
three series without selecting the series separately? Can you make Excel
recognizing the three series in the third column?
It would be very easy if you could simply select the three columns and
define them as X, Y and series. Especially if you have a lot of series...

multiple series from one column
 

You're asking more of Excel than it was designed for. However, it is
designed for data processing. Make a pivot table of your data, which will
allow you to separate the data by label in the Series column. Or sort by
series column, so at least all the values are clumped together.

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


"Maarten" wrote in message
...
Hi,
my data are organized in three columns: X, Y and a column with the series
names (say A, B and C). Is it possible to create a single XY plot for the
three series without selecting the series separately? Can you make Excel
recognizing the three series in the third column?
It would be very easy if you could simply select the three columns and
define them as X, Y and series. Especially if you have a lot of series...