Slopes - or how to show going up hill

B

Brad

Is there a shape that can be used to show going up hill or down hill? - a two
dimensional arrow isn't good enough.

I'm using Visio 2003.
 
W

wr

Hi Brad,

I haven't found any shape with this functionality.
I guess you need to create your own shape.

Here is some help:

First create two custom propertiesr
Prop.direction
Prop.setText
Then create a user-defined cell
User.txtAngle

Then place formulas in the applicable cells:

in the Prop.setText cell
=IF(AND(ATAN2(EndY-BeginY,EndX-BeginX)<0
deg,ATAN2(EndY-BeginY,EndX-BeginX)>-180
deg),SETF(GetRef(Prop.direction),"""going
up"""),SETF(GetRef(Prop.direction),"""going down"""))

in the User.txtAngle cell
=IF(OR(ATAN2(EndY-BeginY,EndX-BeginX)<=-90
deg,ATAN2(EndY-BeginY,EndX-BeginX)>=90 deg),SETF(GetRef(TxtAngle),180
deg),SETF(GetRef(TxtAngle),0 deg))

Now in the NW and NE quadrant the text will display 'going up' and in the SW
and SE quadrant it will display 'going down'

Also in the NW and SW quadrant the txtangle cell will be 0 deg and vice
versa in the NE and SE quadrant it will 180 deg. This is for a better visual
display.

Hope this helps

René
 
B

Brad

What I'm doing is having a map of a golf course that has alot of elevation
changes. It would be nice to be able to have a graphic that would indicate
that. So having the equation on how to graph a line isn't what I was looking
for.
 
B

Brad

Thanks - I will have to try this out. I ended up with an arrow and typing in
up hill or down hill as needed.

I will let you know how this works.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top