Copying an chart from excel with a camera-linked picture embedded

[reclinemusic]

Hi,
I need to make a copy of a Chart (the chart is a standalone tab) that has a camera linked picture of a table of data coming from another tab embedded on the chart.

I just want to copy and paste the chart with the table as an image in to power point.

I used to do this all the time in Excel 2003 but can't do it in 2007. When I paste into power point only the chart shows and not the camera-linked picture of the table of data.

Thanks for any help.

 

[Steve=True]

Copy from Excel

Open PowerPoint

Select Paste>SPECIAL

Select Paste Link in the Paste Special Dialog Box

Steve=True
www.exceldashboardtemplates.com

 

[reclinemusic]

That didn't work. Still the same problem: Just the chart with no camera linked picture.

 

[Steve=True]

worked fine in my 2007 version.

You don't need to use the camera, maybe that is the problem.

Just highlight the cells.

copy

go to powerpoint

paste-special

select paste link radio button

 

[reclinemusic]

I guess you're not understanding what I'm trying to do.

I have a chart on it's own tab.

I need to lay a picture on top of this chart.

This picture needs to be dynamically linked to a table on another tab so I have to use the camera tool.

This picture contains summary backup data for what is on the chart.

The chart, including the camera-linked picture overlayed on the chart needs to be pasted in to power point.

Try doing the above steps in excel 2007 and see if it works for you.

 

[Steve=True]

To make this work in 2007 you May have to Move your chart from its own tab and put it in a spreadsheet.

Then copy cells around chart and cut/paste special in powerpoint.

This worked for me. However In powerpoint I did have to force an Update Link on the Paste Special Link image.

 

[reclinemusic]

I see. Yeah I played around with putting it in a sheet but it didn't look as good.

I ended up writing a macro and copying a picture of the table I needed to embed on the chart. This works well enough.

Private Sub FormatGraphAndTable()

On Error Resume Next

' Delete old sheet
Application.DisplayAlerts = False
Sheets("FormattedChart").Delete
Application.DisplayAlerts = True

'Copy Chart
ActiveSheet.ChartObjects(7).Activate
ActiveChart.ChartArea.Copy

' Duplicate Chart to move to a new location
Range("K27").Select
ActiveSheet.Paste
ActiveSheet.ChartObjects(8).Activate

'Move to new location
ActiveChart.Location Where:=xlLocationAsNewSheet, Name:="FormattedChart"
Sheets("Regression").Select

'Get picture of stat table to put in FormattedChart
Range("M5:O24").Select
Selection.CopyPicture Appearance:=xlScreen, Format:=xlPicture
Sheets("FormattedChart").Select
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.Paste
' Make the background white
Selection.Interior.ColorIndex = 2

End Sub