If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
chart question
I have a reference line that I want to appear on my chart. It's a straight
line (nothing complicated). I've drawn it, and it kind-a works, but everytime I change any data or resize the chart, etc. ... the line moves (then of course I need to look up where it was suppose to be, if I don't have a handy previous printout). Having to move a graphic line "accurately" in Excel is no treat!! Is there any way to lock that line with the chart? Alternatively, is there a way to input such a line another way, so that it remains static on the chart. I did enter a straight line of data points for this, but because of the gap that exists in the space before and after other real data lines, the line doesn't display across the full width of the chart. If this is clear as mud, let me know and I'll try to explain it differently. Thanks. |
#2
|
|||
|
|||
chart question
Best to draw a line as another data series; see
http://peltiertech.com/Excel/Charts/ But if you want to use a graphic line you need to group line & chart. If you has clicked on chart before drawing this would have happened. To fix it: get line in correct place; click chart; hold CTRL and click Line; now right click and select Group best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Cowtoon" wrote in message ... I have a reference line that I want to appear on my chart. It's a straight line (nothing complicated). I've drawn it, and it kind-a works, but everytime I change any data or resize the chart, etc. ... the line moves (then of course I need to look up where it was suppose to be, if I don't have a handy previous printout). Having to move a graphic line "accurately" in Excel is no treat!! Is there any way to lock that line with the chart? Alternatively, is there a way to input such a line another way, so that it remains static on the chart. I did enter a straight line of data points for this, but because of the gap that exists in the space before and after other real data lines, the line doesn't display across the full width of the chart. If this is clear as mud, let me know and I'll try to explain it differently. Thanks. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
mix chart types | Ken Murray | Powerpoint | 7 | April 28th, 2006 02:50 AM |
simple chart question | Shooter | Worksheet Functions | 1 | January 24th, 2006 09:30 PM |
Chart VBA Question | Barb Reinhardt | Charts and Charting | 4 | January 14th, 2006 02:26 PM |
'Closing' chart window *and* removing chart using VBA | Marc R. Bertrand | Charts and Charting | 7 | December 17th, 2003 04:30 PM |
Simple pie chart question | Jim Meyer | Charts and Charting | 2 | October 6th, 2003 05:34 PM |