LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 211
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2nd Axes - primary series data of only 1 series disappears! cheriw Charts and Charting in Excel 1 February 23rd 06 12:32 AM
CHANGE DATA SERIES WITH A COMMAND BUTTON Raymond Willis Charts and Charting in Excel 5 December 5th 05 05:49 PM
is there a way to have data labels on top and inside of a bar? C. Moore Charts and Charting in Excel 3 October 21st 05 07:46 PM
chart data series -- plot a table as a single series hjc Charts and Charting in Excel 7 September 20th 05 05:52 PM
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du TC Excel Worksheet Functions 1 May 12th 05 02:06 AM


All times are GMT +1. The time now is 05:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"