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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
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 |