level line

[Stefi]

Hi All,

I have a line graph with minutes on y axis but scaling may vary from small
values to large ones. I want to draw a level line at 15 minutes with AddLine
method. I can do that manually, but how can I calculate the position of 15
minutes (in points as required by the AddLine method) on y axis if its place
varies with scaling of y axis? (or is there any other way?)

Thanks,
Stefi

 

[Stefi]

What's more, also the actual window size influences the place of 15 minutes

 

[Andy Pope]

Hi,

Rather than adding a line from the drawing toolbar consider using another
data series to draw the line
http://www.andypope.info/charts/averageline.htm

Cheers
Andy

 

[Stefi]

„Stefi†ezt írta:

What's more, also the actual window size influences the place of 15 minutes

 

[Stefi]

Thanks Andy, in the meantime I've found also
http://peltiertech.com/Excel/Charts/AddLine.html
Now I have several ways to choose from!
Stefi