 |
 |
 |
 |
 |
|
|
||||||||||||
|
#1
09-12-2005, 09:51 AM
|
|||
|
|||
|
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. 
|
|
#2
09-13-2005, 06:05 PM
|
|||
|
|||
|
Re: Formatting Legend
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. > >
|
|
#3
09-14-2005, 10:34 PM
|
|||
|
|||
|
Not working
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.
|
|
#4
09-15-2005, 01:05 AM
|
|||
|
|||
|
Re: Formatting Legend
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. > >
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
