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