View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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...