Setting calculated labels

  • Thread starter Thread starter Henning Winkler
  • Start date Start date
H

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
 
Henning said:
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.
Click to expand...

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
 
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
Click to expand...
 
Back
Top