Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
move values text in graphs all series at once. Excel | Charts and Charting in Excel | |||
Trend lines on line graphs | Excel Discussion (Misc queries) | |||
Deleting unused lines between used lines? | Setting up and Configuration of Excel | |||
How do I specify using lines or bars on graphs w/ 2nd value axis? | Charts and Charting in Excel | |||
Line graphs with many lines | New Users to Excel |