Formatting Legend
 

Dear all,

I'm new to this forum and would like to ask the experts here. I have a
slight problem in formatting legend in an excel chart. When I put
legend in the chart and preview it, the legend located just fine, but
.... when I print it, the graphic overlap with the legend and this
really annoyed me. Try moving the graphic, sizing the graphic and etc
but it didn't work !!! Hickss ... pls kindly help me. Thx.


--
sanwijay
------------------------------------------------------------------------
sanwijay's Profile: http://www.excelforum.com/member.php...o&userid=27165
View this thread: http://www.excelforum.com/showthread...hreadid=466760

Sometimes people have problems with charts looking different when
printed. This is often the case when a chart is embedded on a worksheet,
and therefore relatively small compared to the full page. If you select
the chart and print it, though, the chart is treated as if it were on
its own chart sheet, and expanded to fill the whole printed page. To
reliably print an embedded chart, you need to actually print the
worksheet under the chart, or a range of cells that includes the chart.

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


sanwijay wrote:

Dear all,

I'm new to this forum and would like to ask the experts here. I have a
slight problem in formatting legend in an excel chart. When I put
legend in the chart and preview it, the legend located just fine, but
... when I print it, the graphic overlap with the legend and this
really annoyed me. Try moving the graphic, sizing the graphic and etc
but it didn't work !!! Hickss ... pls kindly help me. Thx.

Dear Mr Peltier,

Thank you for your kind attention and help. It's true that I'm using
chart as part of report in a worksheet. I already selected the print
area, and when I previewed it on screen it looked ok but when printed
some mis-allignment exist. Mr Peltier, is there any way to correct this
problem ? Chart always overlapping the legend. Try several time moving
the legend, sizing the chart and legend but nothing seemed to work. The
simplest solution maybe to deactivate the legend and create it outside
the chart, using a cell in worksheet filled with color but it's time
consuming. Perhaps another solution to this problem anyone ? TIA.


--
sanwijay
------------------------------------------------------------------------
sanwijay's Profile: http://www.excelforum.com/member.php...o&userid=27165
View this thread: http://www.excelforum.com/showthread...hreadid=466760

Do you mean print preview on screen was okay, or merely worksheet view
was fine? To get the results I described, you should unselect a chart
prior to calling the print command, so the chart is printed as part of
the worksheet report. (If this is what you are doing already, I
apologize for being obtuse.)

If these steps do not correct the issue, you will need to fudge it
somehow. An old mentor of mine in a metalworking shop would say, Make
the mold wrong to make the part right. If you can predict the error in
advance, you can compensate for it. Not exactly WYSIWYG, but you can at
least make reasonable allowances.

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


sanwijay wrote:

Dear Mr Peltier,

Thank you for your kind attention and help. It's true that I'm using
chart as part of report in a worksheet. I already selected the print
area, and when I previewed it on screen it looked ok but when printed
some mis-allignment exist. Mr Peltier, is there any way to correct this
problem ? Chart always overlapping the legend. Try several time moving
the legend, sizing the chart and legend but nothing seemed to work. The
simplest solution maybe to deactivate the legend and create it outside
the chart, using a cell in worksheet filled with color but it's time
consuming. Perhaps another solution to this problem anyone ? TIA.