Stuart McLachlan
stuart at lexacorp.com.pg
Thu Jun 17 07:53:22 CDT 2004
On 17 Jun 2004 at 8:34, Jim DeMarco wrote: > List, > > Our clinical group wants a graph showing a patient's weight and BMI (a > calculation based on weight and height). Obviously we can graph two > values but these values have different scales (weight could be any > thing from 40-500 lbs and BMI is usually a number less than 20). My > boss seems to think MS Graph (which is what our app uses) can plot a > line graph using more than one scale. Does anyone know a) if this is > true, and b) how to go about doing it? > a. Yes b. Once you have designed the basic chart, right click on the BMI line and select "Format Data Series". Then select Axis and tick "Plot series on Secondary Axis" That will put the BMI dimensions on the right hand Axis. -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support.