Label Max Value on Secondary Y-Axis Stacked Column

[Guest]

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?

 

[Jon Peltier]

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/ChartIndex.html#AxisScales

- Jon

 

[Guest]

Hi and Thank you, Jon,

Can I do this with a stacked column? I'm not sure how to get the Y values
to line straight up the right axis the way you did with those values on the
left in the intriguing examples at your site. Should I start with a
different chart type to begin with? Many thanks,

Luke

 

[Andy Pope]

Hi,

Add a new series to the chart via the Source Data dialog.
Select this series and move to the secondary axis.
Change the chart type to xy-scatter.
Now go back to the Source data dialog and use the values
X: =1.5
Y: =138

The apply data labels to the series, which should be in the top right hand
corner of your chart.

Cheers
Andy

 

[Guest]

Bee-YOO-tiful. Now I see what you guys are talking about, but I would never
have gotten it on my own.

Thanks to you both.

With gratitude inversely proportional to my ability to figure this stuff out,

Luke