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

[Guest]

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.

 

[Jon Peltier]

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

 

[David Biddulph]

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.