Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/105088

From BetaArchive Wiki

PPT: Controlling Background Color on Pasted Excel Objects

PSS ID Number: Q105088 Article last modified on 05-16-1998

windows:3.0,4.0,4.0a,4.0c

WINDOWS

======================================================================

The information in this article applies to:

  • Microsoft PowerPoint for Windows, versions 3.0, 4.0, 4.0a, 4.0c
  • == Microsoft Excel for Windows, versions 4.0, 5.0 ==

SUMMARY

When you paste or embed spreadsheets and charts from Excel into PowerPoint, you have the option of having a clear (transparent) background or an opaque (solid) background. A transparent background lets the colors on your PowerPoint slide show through. An opaque background covers that portion of the slide.

The background pattern/fill color is controlled by a combination of settings in Excel and PowerPoint. In Excel, the setting is the cell or area pattern. In PowerPoint, the setting is the object fill.

MORE INFORMATION

Ordinarily, an Excel object pastes with an opaque white background because the default setting for cell and area pattern is Automatic. When the pattern is set to Automatic (or any color) in Excel, you cannot override that color with a fill in PowerPoint.

To make the Excel object paste with a clear background, or to preserve the option to fill the object in PowerPoint, set its cell or area pattern in Excel to None, as explained below.

To set the cell pattern (background) in Excel

  1. In Excel, select a range of cells.
  2. From the Format menu, choose Patterns.
  3. For clear (fillable) cells, set the Pattern option to None. For opaque cells, set the Pattern option to some color or pattern. NOTE: The foreground and background colors don’t directly affect the cell pattern. They only indirectly affect the color of patterns available.
  4. Close the dialog box by choosing OK.

To set the area pattern (background) of an Excel 4.0 chart

  1. In Excel or PowerPoint, double-click the chart so it appears in its own window.
  2. From the Chart menu, choose Select Chart.
  3. From the Format menu, choose Patterns.
  4. For a clear (fillable) chart, in the Area column, select None. For an opaque chart, in the Area column, select Automatic (white) or some color.
  5. Close the dialog box by choosing OK.

To set the area pattern (background) of an Excel 5.0 chart

  1. In Excel or PowerPoint, double-click the chart so it appears in its own window.
  2. Click the edge of the chart with your right mouse button.
  3. From the menu that appears, choose Format Plot Area.
  4. The Format Plot Area dialog box appears with the Patterns tab active. In the Area section of this dialog box, choose None.
  5. Choose OK.

The chart should now have a transparent background, allowing the PowerPoint slide background to show through.

NOTE: If you are editing an Excel 5.0 chart that has already been embedded into PowerPoint 4.0, you may need to clear the selection of the chart (that is, exit from Excel) before the slide background will show through.

To fill an object in PowerPoint (that is, color its background)

  1. In PowerPoint, select the object.
  2. From the Object menu, choose Fill.
  3. Choose the color of fill that you want to use. (None produces a clear/transparent background.)

To copy an Excel object into PowerPoint

  1. In Excel, select the range of cells or the chart.
  2. From the Edit menu, choose Copy.
  3. Switch to PowerPoint.
  4. From the Edit menu, choose Paste.

For more information about this topic, query on the following words in the Microsoft Knowledge Base:

Excel and PowerPoint and embed and white and black and windows and chart

Additional query words: 3.00 power point powerpt overlap blank see winppt 4.00a 4.00c through accel ====================================================================== Keywords : kbinterop kbole Version : windows:3.0,4.0,4.0a,4.0c Platform : WINDOWS Hardware : x86 Issue type : kbhowto ============================================================================= Copyright Microsoft Corporation 1998.