combination charts: two variables in one series?

[Bob with Q]

I want to plot density (y) and shrinkage (y) vs. temperature (x axis) but
Excel 2003 gives me two lines on a combination chart because the Y axes are
fixed. Can I have one of the y axes adjust to give only one line? Also when
I reverse the values of density the temperature goes to the top of the graph
instead of staying at the bottom. Is all of this possible in Excel?

 

[Andy Pope]

Hi,

To keep the x axis label at the bottom you also need to check the
"Category (x) axis crosses at maximum value" option, which is also on
the scale tab.

Have you selected the shrinkage series and on the format dialog set the
axis to secondary?

Cheers
Andy