multiple series from one column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...
 
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
 
Back
Top