Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Dec 2003
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Trend Charts (2002)

    Is there any way to turn a the lines of a line graph to arrows? We want to create a sales trend graph for presentation purposes and have the end point be an arrow. If not, any other ideas?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Trend Charts (2002)

    The only ways I know:
    add a drawing of a line with the arrow though this is not live

    to make a "live version"
    Instead of using a line chart, you could use a XY-scatter and then "draw the line"
    The attached has a simple example. You need to:
    calc the slope /intercept of trend line (In D1/D2, uses slope/intercept functions)
    enter starting point X-value of line(D5)
    enter starting X-value of Arrow(D6)
    enter Length of X-value of arrow(D8)
    enter Width of X-value of arrow(D9)
    Calc the perp to slope (G1 = -1/D1)
    Calc the Intercept of perp at arrow start (G2 = D6*($D$1-$G$1)+$D$2)

    In H5:I11 I "draw the line to make a line with an arrowhead"
    The line starts at min X,Y
    Goes to start of arrow, goes to lower part of left arrow head, to arrow tip, to lower part of right arrowhead, to the line and then to the arrow head tip.

    The calcs use the appropriate slope/intercept for trend of perpendicular, and has a "check" to adjust the calc if the slope of the trend = 0.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •