Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using multiple criterie in one column to sum another column | Excel Discussion (Misc queries) | |||
Multiple columns of data into one long column | Excel Discussion (Misc queries) | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
how do I change a line series to a column series in excel? | Charts and Charting in Excel |