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?

Label Max Value on Secondary Y-Axis Stacked Column
 

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?

Label Max Value on Secondary Y-Axis Stacked Column
 

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

"Jon Peltier" wrote:

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?

Label Max Value on Secondary Y-Axis Stacked Column
 

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Rutabaga" wrote in message
...
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

"Jon Peltier" wrote:

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?

Label Max Value on Secondary Y-Axis Stacked Column
 

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

"Andy Pope" wrote:

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Rutabaga" wrote in message
...
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

"Jon Peltier" wrote:

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?