Gray Borders around Excel Chart in PowerPoint (2010)

[mswoods1]

I've upgraded to Excel 2010 / PowerPoint 2010 recently and I've started having a problem when I paste charts into PowerPoint from Excel. There are now small gray borders around Excel charts in PowerPoint that were not there before. These charts have no borders in Excel (and these same charts used to show up without borders in PowerPoint 2003 using Excel 2003).

This is really bugging me and I'd like to find a solution.

My process for pasting the chart into PowerPoint is as follows:

1. Select a range around the chart in Excel. (i.e. I select a range of cells, not the chart object)
2. Copy the range
3. Goto PowerPoint and Paste Special as an Enhanced Metafile

One solution to this problem is to select a range of cells which do NOT include the chart borders, i.e. the entire range that I select is within the chart objects boundaries. But it's not a very elegant solution and I believe there should be something easier.

 

[Jbusyy]

I've upgraded to Excel 2010 / PowerPoint 2010 recently and I've started having a problem when I paste charts into PowerPoint from Excel. There are now small gray borders around Excel charts in PowerPoint that were not there before. These charts have no borders in Excel (and these same charts used to show up without borders in PowerPoint 2003 using Excel 2003).

This is really bugging me and I'd like to find a solution.

My process for pasting the chart into PowerPoint is as follows:

1. Select a range around the chart in Excel. (i.e. I select a range of cells, not the chart object)
2. Copy the range
3. Goto PowerPoint and Paste Special as an Enhanced Metafile

One solution to this problem is to select a range of cells which do NOT include the chart borders, i.e. the entire range that I select is within the chart objects boundaries. But it's not a very elegant solution and I believe there should be something easier.

I just upgraded to PPT 2010... and have the exact problem!! I cant find a solution anywhere. Ugh. I registered here just to say this.

 

[mswoods1]

I just upgraded to PPT 2010... and have the exact problem!! I cant find a solution anywhere. Ugh. I registered here just to say this.

Try this:

-Double check that you don't have any border color associated with the chart border (you've probably already done this)
-Make the chart area and chart background transparent (do this by changing the chart and chart area fill to "no fill")
-Make the interior color of the cells around the chart white

 

[Jbusyy]

Try this:

-Double check that you don't have any border color associated with the chart border (you've probably already done this)
-Make the chart area and chart background transparent (do this by changing the chart and chart area fill to "no fill")
-Make the interior color of the cells around the chart white

Thanks you MsWoods1! Colouring the area white around the chart worked. Really poor implementation on Microsofts part!

 

[fhaidacher]

Hi all,

I found out that this behavior is also present with images pasted in worksheets. The slides in PowerPoint look OK, but when you switch to presentation mode, then all the ugly grey borders appear.

I solved it by cutting the image and pasting it again as bitmap in PowerPoint ...

Range("A1:Z20").Copy 'copies the Excel worksheet range
ppSlideObj.Shapes.PasteSpecial(DataType:=ppPasteEnhancedMetafile).Select 'pastes the copied range into PowerPoint as an enhanced metafile
ppSlideObj.Shapes(1).Height = ppAppObj.ActivePresentation.PageSetup.SlideHeight 'auto adjust image height to slide height
ppSlideObj.Shapes(1).Width = ppAppObj.ActivePresentation.PageSetup.SlideWidth 'auto adjust image width to slide width
ppAppObj.ActiveWindow.Selection.ShapeRange.Align msoAlignCenters, msoTrue 'align center
ppAppObj.ActiveWindow.Selection.ShapeRange.Align msoAlignMiddles, msoTrue 'align middle
ppSlideObj.Shapes(1).Cut 'cut enhanced metafile (that we just pasted) *** THIS IS THE TRICK ***
ppSlideObj.Shapes.PasteSpecial(DataType:=ppPasteBitmap).Select 'paste as bitmap *** THIS IS THE TRICK ***
ppAppObj.ActiveWindow.Selection.ShapeRange.Align msoAlignCenters, msoTrue 'align horizontally again
ppAppObj.ActiveWindow.Selection.ShapeRange.Align msoAlignMiddles, msoTrue 'align vertically again

Enjoy!