Copy & Paste Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can Copy & Paste an Excel Chart from one Workbook to another.

However, another User, when copying an Excel chart, and Pasting
into another Workbook, gets the Chart essentially as a "Snapshot"
with "EMBED".

Ideas???

TIA - Bob
 
What's your question? You don't say what you're looking for. What does the
formula bar say in parentheses after "EMBED"?

You can copy the chart as a picture: hold Shift while selecting the Edit
menu, choose Copy Picture, and choose the On Screen and Picture options.

- Jon
 
Jon,

I'll have to check the Formula Bar later today when the User arrives on
Second Shift.

When I copy-&-paste, and get an editable Chart, the Formula Bar
is blank.

Will reply around 6:00 PM Eastern time today.

Thank you,
Bob
 
Jon,

Here's the Formula Bar on the "Snapshot Chart"...
=EMBED("Excel.Chart.8","")

Thank you - Bob
 
I actually expected to see this:

=EMBED("MSGraph.Chart.8","")

meaning a Microsoft Graph Chart object (the one used in PowerPoint and Word)
was embedded in Excel. I honestly don't know how to embed a regular Excel
chart in such a way as to display this kind of thing in the formula bar.

- Jon
 
Jon - Thank you.

As an Access Programmer, my first thought was...
Is that such a thing as "Tools - References" in Excel??

"Something" must be "unusaul" about his Excel installed.

As always, thank you.
Bob
 
Not sure if this helps but I can get =EMBED("Excel.Chart.8","")
when copying a chartobject from xl2000 to xl2003. But I do have to have
both versions open. Simply saving the older version and opening in xl2k3
allowed for normal copy/paste.

Cheers
Andy
 
Back
Top