View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Rutabaga Rutabaga is offline
external usenet poster
 
Posts: 17
Default Label Max Value on Secondary Y-Axis Stacked Column

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?