Using Excel 2003



Trying to plot blood pressure systolic, diastolic, plus upper and lower
control limits on one axis as a line chart superimposed upon bar data points
(weight) driven by secondary axis. Data series are in the order as given
above.



Started with a simple line chart for the first four series then decided to
add fifth (weight). Changed "Chart Type" to "Line - Column on 2 Axes" by
simply selecting that type from among listings and watched the example
change shape. Actual chart changed to all columns driven from the primary
axis. Examined the source data, found the last column (weight) missing from
the "Secondary Category (x) axis labels", changed the range to include that
last data column, and watched the bar chart add one simple line driven by
the secondary chart. Unfortunately, it wasn't the "Weight" column as I
expected it to be; it was the lower control limit (forth) data column.



I realize this is a lot to ask for but if someone can point me in the right
direction, I'd appreciate it.