PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Miss- position of text box in chart

Reply

Miss- position of text box in chart

 
Thread Tools Rate Thread
Old 11-02-2004, 09:26 AM   #1
eric
Guest
 
Posts: n/a
Default Miss- position of text box in chart


I have a problem on below :

When i generate the chart there after i added in the text
with text box to a certain location within the chart, but
after the position of the text shifted once i preview and
even printed out. the text just missalignment with what i
have been placed earlier on.

Thanks for the help~~!
  Reply With Quote
Old 11-02-2004, 04:36 PM   #2
Jon Peltier
Guest
 
Posts: n/a
Default Re: Miss- position of text box in chart

Eric -

Add a dummy XY series to the chart, with a data point located everywhere
you want a label. Format the series to be invisible (no marker, no
line), then use one of the free Excel add-ins* to apply labels from a
worksheet range to the dummy points.

* Rob Bovey's Chart Labeler (http://appspro.com)
John Walkenbach's Chart Tools (http://j-walk.com)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

eric wrote:

> I have a problem on below :
>
> When i generate the chart there after i added in the text
> with text box to a certain location within the chart, but
> after the position of the text shifted once i preview and
> even printed out. the text just missalignment with what i
> have been placed earlier on.
>
> Thanks for the help~~!


  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off