Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Remove Chart Canvas or make transparent in Excel 07 on XP
Is there a way to remove the chart canvas or make it transparent? I have a
chart that needs to fill the page and have a footer. I can stretch it to fill the page, but the canvas then obscures the footer. Is there a fit to page feature? That still may not work, but I also need to know and try that. When managers are used to seeing product in a certain way, they don't like to hear that, just because of a new version, you can no longer give them what they want. Nor do they believe it. Thank you. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Remove Chart Canvas or make transparent in Excel 07 on XP
Select the Chart Area (the outermost rectangle which encloses the entire
chart), right click, and choose Format. Where you set the fill color (I forget the new names of the tabs), choose No Fill or None. Repeat this for the Plot Area, which is the rectangle defined on two edges by the axes. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "LisaK" wrote in message ... Is there a way to remove the chart canvas or make it transparent? I have a chart that needs to fill the page and have a footer. I can stretch it to fill the page, but the canvas then obscures the footer. Is there a fit to page feature? That still may not work, but I also need to know and try that. When managers are used to seeing product in a certain way, they don't like to hear that, just because of a new version, you can no longer give them what they want. Nor do they believe it. Thank you. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Remove Chart Canvas or make transparent in Excel 07 on XP
In 2007 you right-click the Plot Area and choose Format Plot Area, Fill tab,
No Fill. -- If this helps, please click the Yes button Cheers, Shane Devenshire "LisaK" wrote: Is there a way to remove the chart canvas or make it transparent? I have a chart that needs to fill the page and have a footer. I can stretch it to fill the page, but the canvas then obscures the footer. Is there a fit to page feature? That still may not work, but I also need to know and try that. When managers are used to seeing product in a certain way, they don't like to hear that, just because of a new version, you can no longer give them what they want. Nor do they believe it. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to make transparent background | New Users to Excel | |||
How to make inserted picture transparent so the cells will show? | Excel Discussion (Misc queries) | |||
Excel 2003: How to make transparent columns in Excel chart? | Excel Discussion (Misc queries) | |||
transparent level/limit in an Excel chart (3D) | Charts and Charting in Excel | |||
chart transparent fill | Charts and Charting in Excel |