Setting calculated labels

[Henning Winkler]

I want to set calculated values on a sencondary axis in a simple
linediagram.

On the left side of the diagram the axis values are

100
50
0
-50
-100

On the right side I want to set my calculated values, for example

10
125
infinite (correct ???)
-125
-10

at the same position as the left.
Any idea, how I can solve this problem.

Thanks.

Henning

 

[dvt]

I want to set calculated values on a sencondary axis in a simple
linediagram.

On the left side of the diagram the axis values are

100
50
0
-50
-100

On the right side I want to set my calculated values, for example

10
125
infinite (correct ???)
-125
-10

at the same position as the left.
Any idea, how I can solve this problem.

Sure. Jon Peltier has it all figured out and has been nice enough to post a
tutorial at...

http://www.geocities.com/jonpeltier/Excel/Charts/ArbitraryAxis.html

You will need to slightly modify his approach since your goals are slightly
different than his, but I think you'll be able to make it work. The basic
concept of using a dummy series, putting the points at the desired location,
and labeling that series will be appropriate for your needs.

Dave
dvt at psu dot edu

 

[Henning Winkler]

hi Dave,

looks good.

thanks.

Henning

Sure. Jon Peltier has it all figured out and has been nice enough to post a
tutorial at...

http://www.geocities.com/jonpeltier/Excel/Charts/ArbitraryAxis.html

You will need to slightly modify his approach since your goals are slightly
different than his, but I think you'll be able to make it work. The basic
concept of using a dummy series, putting the points at the desired location,
and labeling that series will be appropriate for your needs.

Dave
dvt at psu dot edu