how to move lines in conjunction with graphs
 

Hi, I've drawn a dotted line across my scatter graph but whenever i move
the graphs the dotted line stays in its original place. is there a way
to make the line part of the graph so that it resizes and moves in
conjunction with the graph?
Thanks


--
Shoque
------------------------------------------------------------------------
Shoque's Profile: http://www.excelforum.com/member.php...o&userid=36320
View this thread: http://www.excelforum.com/showthread...hreadid=564595

how to move lines in conjunction with graphs
 

I assume you mean the line is derived from the Drawing tool bar. To have the
chart serve as the container for the line as opposed to the worksheet, first
activate the chart (the sizing handles should be visible). Then click the
line icon on the Drawing tool bar and click inside the chart. Drag until the
line is visible. You can now size and position the line as desired. After
unselecting the chart, if you move and/or resize it, the line should behave
as desired.

Regards,
Greg

"Shoque" wrote:


Hi, I've drawn a dotted line across my scatter graph but whenever i move
the graphs the dotted line stays in its original place. is there a way
to make the line part of the graph so that it resizes and moves in
conjunction with the graph?
Thanks


--
Shoque
------------------------------------------------------------------------
Shoque's Profile: http://www.excelforum.com/member.php...o&userid=36320
View this thread: http://www.excelforum.com/showthread...hreadid=564595

how to move lines in conjunction with graphs
 

i tried that actually, but when i go to click inside the chart to draw
my graph the sizing handles automatically disappear. Whats happening
there and what am i doing wrong. I simply click on the chart to
activate it right?

Greg Wilson Wrote:
I assume you mean the line is derived from the Drawing tool bar. To have
the
chart serve as the container for the line as opposed to the worksheet,
first
activate the chart (the sizing handles should be visible). Then click
the
line icon on the Drawing tool bar and click inside the chart. Drag
until the
line is visible. You can now size and position the line as desired.
After
unselecting the chart, if you move and/or resize it, the line should
behave
as desired.

Regards,
Greg


--
Shoque
------------------------------------------------------------------------
Shoque's Profile: http://www.excelforum.com/member.php...o&userid=36320
View this thread: http://www.excelforum.com/showthread...hreadid=564595

how to move lines in conjunction with graphs
 

It doesn't matter if the sizing handles disappear after clicking inside the
chart. If the chart was active when you clicked the line icon on the Drawing
tool bar then the chart should *own* the line instead of the worksheet after
placing it on the chart. Try it.

Greg

"Shoque" wrote:


i tried that actually, but when i go to click inside the chart to draw
my graph the sizing handles automatically disappear. Whats happening
there and what am i doing wrong. I simply click on the chart to
activate it right?

Greg Wilson Wrote:
I assume you mean the line is derived from the Drawing tool bar. To have
the
chart serve as the container for the line as opposed to the worksheet,
first
activate the chart (the sizing handles should be visible). Then click
the
line icon on the Drawing tool bar and click inside the chart. Drag
until the
line is visible. You can now size and position the line as desired.
After
unselecting the chart, if you move and/or resize it, the line should
behave
as desired.

Regards,
Greg


--
Shoque
------------------------------------------------------------------------
Shoque's Profile: http://www.excelforum.com/member.php...o&userid=36320
View this thread: http://www.excelforum.com/showthread...hreadid=564595

how to move lines in conjunction with graphs
 

You could also add the line as another series in the chart. This will force
the line to move properly if the axis scale changes:

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Shoque" wrote in
message ...

Hi, I've drawn a dotted line across my scatter graph but whenever i move
the graphs the dotted line stays in its original place. is there a way
to make the line part of the graph so that it resizes and moves in
conjunction with the graph?
Thanks


--
Shoque
------------------------------------------------------------------------
Shoque's Profile:
http://www.excelforum.com/member.php...o&userid=36320
View this thread: http://www.excelforum.com/showthread...hreadid=564595