On Mon, 6 Nov 2006, in microsoft.public.excel.charting,
Jon Peltier said:

That also works. I didn't know if you needed to display the secondary X
axis. Changing the setting as you did hides it behind the primary X axis, or
sometimes shows both overlapping themselves..

I didn't exactly need to, but it was nice to have tick marks top and
bottom. As it happens, I can still have that, by checking "X axis
crosses at maximum value" for the primary axis. When I thought I had no
other alternative, I was going to rebuild the whole graph starting from
the bars, and putting the scatter ranges on after, but this is less
hassle :-) And here is the finished product:

http://www.branta.demon.co.uk/politi..._balance_2.png

Note, as a final twist, the labels on the bottom are actually the
primary X axis labels, even though the primary X axis is at the top and
the secondary at the bottom--I set the labels to "Low" instead of "Next
to axis".

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.