Problem drawing lines on charts

I am running Excel 2003, SP1 on a Windows XP computer. I have recently
started having problems drawing lines on charts using the drawing tool. I
used to be able to draw a line on a chart and it would print out in that
location. Now if I put a line on a chart, it prints about 1/4" above where
I want it to go. I have to then move the line to a lower location to match
the print preview to get it to print out correctly. Has anyone experienced
this problem and if so, is there a setting or solution. I've tried letting
Excel create the chart, putting in the line and then previewing for printing
at 100%. I've also tried setting the print area around the chart to lock
the chart into an area and then previewing. Neither one solves the problem.

I can't help but think there is a setting off because I used to be able to
do this and the screen view and print view were the same.

One small thought. Is zoom the same?

--
Don Guillett
SalesAid Software
donaldb@281.com
"Susan Lambert" <slambert@ironcasting.org> wrote in message
news:Ovr8mH71EHA.824@TK2MSFTNGP11.phx.gbl...
> I am running Excel 2003, SP1 on a Windows XP computer. I have recently
> started having problems drawing lines on charts using the drawing tool.
I
> used to be able to draw a line on a chart and it would print out in that
> location. Now if I put a line on a chart, it prints about 1/4" above
where
> I want it to go. I have to then move the line to a lower location to
match
> the print preview to get it to print out correctly. Has anyone
experienced
> this problem and if so, is there a setting or solution. I've tried
letting
> Excel create the chart, putting in the line and then previewing for
printing
> at 100%. I've also tried setting the print area around the chart to lock
> the chart into an area and then previewing. Neither one solves the
problem.
>
> I can't help but think there is a setting off because I used to be able to
> do this and the screen view and print view were the same.
>
>

It's not just viewing but printing as well. I tried setting the zoom on the
spreadsheet to the same as preview but the lines are still 1/4" higher in
preview and printed than where I put them on the spreadsheet.

I'm wondering if there is a compatibility issue with the aspect ratio of the
draw tool in SP1. It's very frustrating as we draw a lot on finished charts
and it consumes a lot of time to play around with the lines to get them to
print in the correct position.


"Don Guillett" <donaldb@281.com> wrote in message
news:O46Y8Q71EHA.2540@TK2MSFTNGP09.phx.gbl...
> One small thought. Is zoom the same?
>
> --
> Don Guillett
> SalesAid Software
> donaldb@281.com
> "Susan Lambert" <slambert@ironcasting.org> wrote in message
> news:Ovr8mH71EHA.824@TK2MSFTNGP11.phx.gbl...
>> I am running Excel 2003, SP1 on a Windows XP computer. I have recently
>> started having problems drawing lines on charts using the drawing tool.
> I
>> used to be able to draw a line on a chart and it would print out in that
>> location. Now if I put a line on a chart, it prints about 1/4" above
> where
>> I want it to go. I have to then move the line to a lower location to
> match
>> the print preview to get it to print out correctly. Has anyone
> experienced
>> this problem and if so, is there a setting or solution. I've tried
> letting
>> Excel create the chart, putting in the line and then previewing for
> printing
>> at 100%. I've also tried setting the print area around the chart to
>> lock
>> the chart into an area and then previewing. Neither one solves the
> problem.
>>
>> I can't help but think there is a setting off because I used to be able
>> to
>> do this and the screen view and print view were the same.
>>
>>
>
>

It won't be of any consolation but I just tried this with xl2002 sp2 with no
problems of viewing,previewing, and printing all being the same.

--
Don Guillett
SalesAid Software
donaldb@281.com
"Susan Lambert" <slambert@ironcasting.org> wrote in message
news:u$fosN81EHA.2016@TK2MSFTNGP15.phx.gbl...
> It's not just viewing but printing as well. I tried setting the zoom on
the
> spreadsheet to the same as preview but the lines are still 1/4" higher in
> preview and printed than where I put them on the spreadsheet.
>
> I'm wondering if there is a compatibility issue with the aspect ratio of
the
> draw tool in SP1. It's very frustrating as we draw a lot on finished
charts
> and it consumes a lot of time to play around with the lines to get them to
> print in the correct position.
>
>
> "Don Guillett" <donaldb@281.com> wrote in message
> news:O46Y8Q71EHA.2540@TK2MSFTNGP09.phx.gbl...
> > One small thought. Is zoom the same?
> >
> > --
> > Don Guillett
> > SalesAid Software
> > donaldb@281.com
> > "Susan Lambert" <slambert@ironcasting.org> wrote in message
> > news:Ovr8mH71EHA.824@TK2MSFTNGP11.phx.gbl...
> >> I am running Excel 2003, SP1 on a Windows XP computer. I have recently
> >> started having problems drawing lines on charts using the drawing tool.
> > I
> >> used to be able to draw a line on a chart and it would print out in
that
> >> location. Now if I put a line on a chart, it prints about 1/4" above
> > where
> >> I want it to go. I have to then move the line to a lower location to
> > match
> >> the print preview to get it to print out correctly. Has anyone
> > experienced
> >> this problem and if so, is there a setting or solution. I've tried
> > letting
> >> Excel create the chart, putting in the line and then previewing for
> > printing
> >> at 100%. I've also tried setting the print area around the chart to
> >> lock
> >> the chart into an area and then previewing. Neither one solves the
> > problem.
> >>
> >> I can't help but think there is a setting off because I used to be able
> >> to
> >> do this and the screen view and print view were the same.
> >>
> >>
> >
> >
>
>

Hi Susan,
When I draw a line on a chart I do this:
1) Click chart to activate it
2) Click and use Drawing tool
If step 1 is omitted, the chart and the line are not grouped. Move one and
the other stays unmoved.
If you need to group existing items click the line (you may need first to
right click and use Bring to Front, hold CTRL and click the chart; right
click inside chart and use Group.

How this is of some help

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"Susan Lambert" <slambert@ironcasting.org> wrote in message
news:Ovr8mH71EHA.824@TK2MSFTNGP11.phx.gbl...
>I am running Excel 2003, SP1 on a Windows XP computer. I have recently
>started having problems drawing lines on charts using the drawing tool. I
>used to be able to draw a line on a chart and it would print out in that
>location. Now if I put a line on a chart, it prints about 1/4" above where
>I want it to go. I have to then move the line to a lower location to match
>the print preview to get it to print out correctly. Has anyone experienced
>this problem and if so, is there a setting or solution. I've tried letting
>Excel create the chart, putting in the line and then previewing for
>printing at 100%. I've also tried setting the print area around the chart
>to lock the chart into an area and then previewing. Neither one solves the
>problem.
>
> I can't help but think there is a setting off because I used to be able to
> do this and the screen view and print view were the same.
>

Yes, I am doing this when I input the lines. The lines are there on the
printed copy, they are just not where they are supposed to be. They are off
in print preview also. That has only started happening recently after we
installed Office 2003 SP1. I'll try the grouping objects and see if that
helps. Thanks.


"Bernard Liengme" <bliengme@stfx.TRUENORTH.ca> wrote in message
news:uRfYCE91EHA.804@TK2MSFTNGP12.phx.gbl...
> Hi Susan,
> When I draw a line on a chart I do this:
> 1) Click chart to activate it
> 2) Click and use Drawing tool
> If step 1 is omitted, the chart and the line are not grouped. Move one and
> the other stays unmoved.
> If you need to group existing items click the line (you may need first to
> right click and use Bring to Front, hold CTRL and click the chart; right
> click inside chart and use Group.
>
> How this is of some help
>
> --
> Bernard Liengme
> www.stfx.ca/people/bliengme
> remove CAPS in email address
>
>
> "Susan Lambert" <slambert@ironcasting.org> wrote in message
> news:Ovr8mH71EHA.824@TK2MSFTNGP11.phx.gbl...
>>I am running Excel 2003, SP1 on a Windows XP computer. I have recently
>>started having problems drawing lines on charts using the drawing tool.
>>I used to be able to draw a line on a chart and it would print out in that
>>location. Now if I put a line on a chart, it prints about 1/4" above
>>where I want it to go. I have to then move the line to a lower location
>>to match the print preview to get it to print out correctly. Has anyone
>>experienced this problem and if so, is there a setting or solution. I've
>>tried letting Excel create the chart, putting in the line and then
>>previewing for printing at 100%. I've also tried setting the print area
>>around the chart to lock the chart into an area and then previewing.
>>Neither one solves the problem.
>>
>> I can't help but think there is a setting off because I used to be able
>> to do this and the screen view and print view were the same.
>>
>
>

Susan -

Could you add the line as another series in the chart? It will remain locked to the
X,Y coordinates you used to plot it. Here are some examples:

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

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

Susan Lambert wrote:

> I am running Excel 2003, SP1 on a Windows XP computer. I have recently
> started having problems drawing lines on charts using the drawing tool. I
> used to be able to draw a line on a chart and it would print out in that
> location. Now if I put a line on a chart, it prints about 1/4" above where
> I want it to go. I have to then move the line to a lower location to match
> the print preview to get it to print out correctly. Has anyone experienced
> this problem and if so, is there a setting or solution. I've tried letting
> Excel create the chart, putting in the line and then previewing for printing
> at 100%. I've also tried setting the print area around the chart to lock
> the chart into an area and then previewing. Neither one solves the problem.
>
> I can't help but think there is a setting off because I used to be able to
> do this and the screen view and print view were the same.
>
>

Susan,

See if your printer manufacturer has some updated drivers on their website.


Regards,
Vic Eldridge



"Susan Lambert" wrote:

> Yes, I am doing this when I input the lines. The lines are there on the
> printed copy, they are just not where they are supposed to be. They are off
> in print preview also. That has only started happening recently after we
> installed Office 2003 SP1. I'll try the grouping objects and see if that
> helps. Thanks.
>
>
> "Bernard Liengme" <bliengme@stfx.TRUENORTH.ca> wrote in message
> news:uRfYCE91EHA.804@TK2MSFTNGP12.phx.gbl...
> > Hi Susan,
> > When I draw a line on a chart I do this:
> > 1) Click chart to activate it
> > 2) Click and use Drawing tool
> > If step 1 is omitted, the chart and the line are not grouped. Move one and
> > the other stays unmoved.
> > If you need to group existing items click the line (you may need first to
> > right click and use Bring to Front, hold CTRL and click the chart; right
> > click inside chart and use Group.
> >
> > How this is of some help
> >
> > --
> > Bernard Liengme
> > www.stfx.ca/people/bliengme
> > remove CAPS in email address
> >
> >
> > "Susan Lambert" <slambert@ironcasting.org> wrote in message
> > news:Ovr8mH71EHA.824@TK2MSFTNGP11.phx.gbl...
> >>I am running Excel 2003, SP1 on a Windows XP computer. I have recently
> >>started having problems drawing lines on charts using the drawing tool.
> >>I used to be able to draw a line on a chart and it would print out in that
> >>location. Now if I put a line on a chart, it prints about 1/4" above
> >>where I want it to go. I have to then move the line to a lower location
> >>to match the print preview to get it to print out correctly. Has anyone
> >>experienced this problem and if so, is there a setting or solution. I've
> >>tried letting Excel create the chart, putting in the line and then
> >>previewing for printing at 100%. I've also tried setting the print area
> >>around the chart to lock the chart into an area and then previewing.
> >>Neither one solves the problem.
> >>
> >> I can't help but think there is a setting off because I used to be able
> >> to do this and the screen view and print view were the same.
> >>
> >
> >
>
>
>