multiple series from one column

M

Maarten

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...
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Multiple Fields without Dialog closing between each... 0
VBA - exporting serial letters to single documents 0
adding trendline to plots from multiple series 1
define series in scatterplot from column 0
xy scatter - multiple series 0
Can you input multiple series names and values with a single definedname ? 0
Multiple XY pairs in scatter plot Excel 2007 2
Scatter plots in excel 2007 1

Top