Page 1 of 2 12 LastLast
Results 1 to 15 of 23
  1. #1
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Kitchener, Ontario, Canada
    Posts
    228
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Chart (2002/2003)

    Is there any way of dragging / dropping a line directly onto a chart.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Chart (2002/2003)

    If you show the Drawing toolbar, you can draw lines (and other graphic objects) on a chart. Be warned, though, that since Excel is not really WYSIWYG, the printed result may differ slightly from the onscreen display (the graphic objects may shift a little).
    Or did you mean something else?

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Chart (2002/2003)

    In addition to Hans' response, you can highlight a range of data and drag it onto a chart to create a new series, if that's what you mean.
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Kitchener, Ontario, Canada
    Posts
    228
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Chart (2002/2003)

    Thanks Guys

    I will try to describ this as best as I can. The chart would be a line chart......
    first (series) line would be the data I am tracking
    second (series) line is a limit line that looks for the first line passing above or below it.
    What I am looking for is some way of moving the second line directly on the chart (say grabbing it with the pointer and moving it up and down right on the chart).

    I hope that this helps explain.... I don't think Excel chart function can do this but you guys have surprised me time and time again with metods of doing things.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Chart (2002/2003)

    You cannot drag the line segments of a line chart, but you can drag the data points up and down:
    - Click on a series to select it.
    - Click on a data point of the series.
    - If you hover the mouse pointer over the selected point, it will change to an up-down arrow.
    - You can now drag the point up and down.
    - Please note that this will alter the source data!

  6. #6
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Kitchener, Ontario, Canada
    Posts
    228
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Chart (2002/2003)

    Could you then have 1 point for moving and link that value to all the other points in the source data. that way if you move the 1 point its value changes.... this value is in a table of source data.... all the other numbers in the source data are linked to the moving point valus.

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Chart (2002/2003)

    You could have source data consisting of one cell with a number value, and the rest with formulas referring to the first cell.
    If you move the data point corresponding to the first cell, the value of the first cell will change, and the formulas in the other cells will be recalculated automatically.

    (If you try to move a point corresponding to a cell with a formula, you will start the Goal Seeker.)

  8. #8
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Kitchener, Ontario, Canada
    Posts
    228
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Chart (2002/2003)

    Hans,

    Again I need to say thank you.. great stuff......

  9. #9
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Chart (2002/2003)

    Corey,
    To make life easier (particularly if anyone else is going to use this), you might put a spinner control from the Forms toolbar onto the chart with its linked cell set to the cell the others refer to. That way, when you click up or down on the spinner, the line will move accordingly. (You will need to ensure that the min and max values of the spinner are adequate).
    See attached for a rudimentary example.
    Regards,
    Rory

    Microsoft MVP - Excel

  10. #10
    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: Chart (2002/2003)

    In addition to a spinner, a scrollbar would work nicely. You can make it the same length as the axis so the button "matches" where the line is. You can control it in 3 ways:
    Gross changes by dragging the button
    Medium changes by clicking above or below the button
    Fine control by clicking the up/down arrows.

    Steve

  11. #11
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Chart (2002/2003)

    Steve,
    Nice idea - I think I chose a spinner because the values I was looking at in my test were so small. In real world applications, a scroll bar is almost certainly a better bet!
    Regards,
    Rory

    Microsoft MVP - Excel

  12. #12
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Chart (2002/2003)

    Steve,
    The one down side is that on a vertical axis, the scroll bar moves the opposite way to the line.
    Regards,
    Rory

    Microsoft MVP - Excel

  13. #13
    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: Chart (2002/2003)

    <P ID="edit" class=small>(Edited by sdckapr on 23-Feb-05 12:19. Forgot to add attachment)</P>It depends on how you set it up. (note I used a trick to allow the reversal and to allow incrementing by <1)

    The button can be dragged
    The scroll area (page change) goes up by 1
    and the arrows go up +/- 0.1

    I want from 0 to 7 so I used the range 0 to 70 in the cell link (F1)
    Then I use the formula in the cell you had used as the link (C4)
    =7-F1/10

    You could also modify to increment by 0.01 (use 0 to 700 and the formula 7-f1/100.)

    You don't have to use the linked cell value directly...

    Steve

  14. #14
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Chart (2002/2003)

    Very cunning! <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>
    Regards,
    Rory

    Microsoft MVP - Excel

  15. #15
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Kitchener, Ontario, Canada
    Posts
    228
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Chart (2002/2003)

    How do you do that say with a button

Page 1 of 2 12 LastLast

Posting Permissions

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