Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
holg3r
 
Posts: n/a
Default How to attach legend frame to chart frame?


I moved the legend of a chart inside the chart such thatthe legend frame
aligns with the chart frame. However, it turns out that it only
*appears* to be aligned -- when I look at the print preview (or simply
print it) or when I export the whole chart to other applications such
as MS-Word, the two frames do not lign up at all. Likewise when I only
chage the zoom factor.
Moreover, even within the Excel standard view, the alignment gets
distorted almost every time I enter and exit the chart (even when I
make no changes to the chart whatsoever).

Is there any way to tell Excel to permanently attach the legend to the
chart frame in the desired aligned position?

Thanx,
Holger


--
holg3r
------------------------------------------------------------------------
holg3r's Profile: http://www.excelforum.com/member.php...o&userid=23836
View this thread: http://www.excelforum.com/showthread...hreadid=385178

  #2   Report Post  
bj
 
Posts: n/a
Default

do you have the chart located on new sheet of embeded on a different sheet.
for formating, it works best on its own shhet such that what you see is
approximately what you get.

"holg3r" wrote:


I moved the legend of a chart inside the chart such thatthe legend frame
aligns with the chart frame. However, it turns out that it only
*appears* to be aligned -- when I look at the print preview (or simply
print it) or when I export the whole chart to other applications such
as MS-Word, the two frames do not lign up at all. Likewise when I only
chage the zoom factor.
Moreover, even within the Excel standard view, the alignment gets
distorted almost every time I enter and exit the chart (even when I
make no changes to the chart whatsoever).

Is there any way to tell Excel to permanently attach the legend to the
chart frame in the desired aligned position?

Thanx,
Holger


--
holg3r
------------------------------------------------------------------------
holg3r's Profile: http://www.excelforum.com/member.php...o&userid=23836
View this thread: http://www.excelforum.com/showthread...hreadid=385178


  #3   Report Post  
holg3r
 
Posts: n/a
Default


Thanks for this suggestion.
My charts are indeed embedded in the worksheet of their underlying
data...
I'll experiment with using a separate sheet for each chart...

Holger


--
holg3r
------------------------------------------------------------------------
holg3r's Profile: http://www.excelforum.com/member.php...o&userid=23836
View this thread: http://www.excelforum.com/showthread...hreadid=385178

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stack Chart Legend Display John Charts and Charting in Excel 1 May 15th 05 03:44 AM
Urgent Chart Assistance Brent E Charts and Charting in Excel 1 May 10th 05 09:09 AM
Urgent Chart Questions Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM
Urgent Chart Assistance Requested Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM
Chart Legend Larry Charts and Charting in Excel 4 April 11th 05 10:44 PM


All times are GMT +1. The time now is 12:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"