Is it possible to filter the data inside the series command?
 

I have the height of 149 patient in one column named "height". 78 of them are
male and 71 are female.
I want to draw the height chart for male and female separetly. (x-axis has
no meaning here and y-axis is the height)
I want the chart to have two series one for male and the other for female
and draw two separate line in the chart. Ideally I want both lines to appear
from a min value to max value (both line shows the increasing trend)

I can draw the chart if I I can put the height for male and female in 2
separate columns and my problem is that I have the height for both of tem in
one column. Is there any solution for this issue. I was thinking if it could
be possible to filter the data inside the series command.

--
Rasoul Khoshravan Azar
Kobe University, Kobe, Japan

Is it possible to filter the data inside the series command?
 

You cannot filter the data in the series formula. You would have to filter
using the worksheet, filtering either the original data or a range linked to
the original data.

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


"Khoshravan" wrote in message
...
I have the height of 149 patient in one column named "height". 78 of them
are
male and 71 are female.
I want to draw the height chart for male and female separetly. (x-axis has
no meaning here and y-axis is the height)
I want the chart to have two series one for male and the other for female
and draw two separate line in the chart. Ideally I want both lines to
appear
from a min value to max value (both line shows the increasing trend)

I can draw the chart if I I can put the height for male and female in 2
separate columns and my problem is that I have the height for both of tem
in
one column. Is there any solution for this issue. I was thinking if it
could
be possible to filter the data inside the series command.

--
Rasoul Khoshravan Azar
Kobe University, Kobe, Japan

Is it possible to filter the data inside the series command?
 

So what you need to do on your spreadsheet is to use an appropriate formula
to extract the data from your one column into the relevant one of two new
columns, and plot from there.
--
David Biddulph

"Khoshravan" wrote in message
...
I have the height of 149 patient in one column named "height". 78 of them
are
male and 71 are female.
I want to draw the height chart for male and female separetly. (x-axis has
no meaning here and y-axis is the height)
I want the chart to have two series one for male and the other for female
and draw two separate line in the chart. Ideally I want both lines to
appear
from a min value to max value (both line shows the increasing trend)

I can draw the chart if I I can put the height for male and female in 2
separate columns and my problem is that I have the height for both of tem
in
one column. Is there any solution for this issue. I was thinking if it
could
be possible to filter the data inside the series command.

--
Rasoul Khoshravan Azar
Kobe University, Kobe, Japan