Excel 2007 Chart Pasting Issue

mbdeming

New Member
Joined
May 27, 2009
Messages
4
I have created a standard column chart in
excel and customized the legend (by deleting a series label) and
pasting over this chart into Powerpoint (Paste Special).
Unfortunately the changes made to the legend in excel are not
maintained in Powerpoint. Can you please help? Is this a bug?

Thanks,

MD
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
If you are using Office 2007, I recomend you to create your table directly from Powerpoint; when you are skipped to excel to enter data, you can just copy from your date source and paste it in the new excel window opened by Powerpoint when creating a chart.
The formating process is exactly the same as in Excel...
Kindly
 
Upvote 0
I think this would be one option but I would like all my charts driven from a single source (Excel) as opposed to two different sources. Are there any other recommendations which would allow me to create teh table in excel and copy it over to Powerpoint and still maintain changes made in Excel?
 
Upvote 0
I'm sorry, I'm a french speaker and I don't know automatically the corresponding functions in english, I hope I can still be of help!


  • After copying your chart in excel,
  • In PowerPoint, Use then Paste Special ---> Tick the 2nd option after Paste (in french: Coller avec Liaison)
Any changes from Excel will change your chart in PowerPoint
Kindly
 
Upvote 0
I've come across this issue before as well... The solution I used was pasting the chart as an image (jpg).. You won't be able to manipulate it in powerpoint, but it will keep all of your changes. To do this, and I'll translate the french reply(sort of).

Paste Special, and pick what type you want... I prefer JPG. and it will paste an image instead of the actual graph.

Hope that helps.
 
Upvote 0

Forum statistics

Threads
1,214,780
Messages
6,121,522
Members
449,037
Latest member
tmmotairi

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top