Instead of an official secondary axis, I would use a dummy XY series for the
values along the right edge of the chart. In addition to the ticks spaced 20
units apart, I'd also add one at the maximum value. See these examples:

http://peltiertech.com/Excel/Charts/...tml#AxisScales

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Rutabaga" wrote in message
...
Hello,

I have a stacked column chart (made to appear as a thermometer), so the
primary Y (along the left) displays in increments of 10%, with 100%
displayed
at the top of the thermometer. Fine. The secondary Y-axis is based on
values, the maximum being 138. I'd like '138' to appear at the top
(opposite
'100%') but it's precluded from doing so--the ticks on the chart are in
increments of 20, so the last number displayed is 120. I'd like to keep
those increments, but just force a '138' to appear next to a tick at the
top
of that Y-axis scale. Is this do-able?