Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2nd Axes - primary series data of only 1 series disappears! | Charts and Charting in Excel | |||
CHANGE DATA SERIES WITH A COMMAND BUTTON | Charts and Charting in Excel | |||
is there a way to have data labels on top and inside of a bar? | Charts and Charting in Excel | |||
chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |