将未链接的Excel图表粘贴到Powerpoint [英] Paste Unlinked Excel Chart to Powerpoint

问题描述

我目前正在从事一个将50多个Excel图表组转换为PowerPoint演示文稿的项目.我正在比较50多个项目，并制作50多个相同的图表.我在excel工作簿中进行设置的方式是，图表始终是相同的图表(即图表2)，但是通过更改唯一的ID号，我的图表将来自工作表的不同区域.

I'm currently working on a project transferring 50+ groups of Excel Charts to a powerpoint presentation. I have 50+ items that I'm comparing and making 50+ identical charts. The way that I have it set up in my excel workbook is that the chart is always the same chart (ie Chart 2), but by changing a unique ID number, my chart will source from a different area of the worksheet.

在通常情况下，我只是将图表复制并粘贴为图片.

In the usual case, I would just copy and paste the chart as a picture.

但是，就我而言，我还需要消除所有< 10％的数据标签.我已经找到了在Powerpoint中删除< 10％数据标签的代码，但不是excel.为了执行此代码，我必须将对象保持为图表"格式.不幸的是，由于我将图表设置为可以提供不同数据的同一图表，因此，每当我更改唯一的ID号以复制新图表时，我以前的图表已被复制到Powerpoint中，它们本身就会更新"，就像信息来自最新项目.

However, in my case, I also need to get rid of all data labels <10%. I have found a code to do delete <10% datalabels in Powerpoint, but not excel. In order to execute this code, I have to keep the object in "chart" format. Unfortunately, because of how I have set up my charts to be the same chart that can source different data, whenever I change a unique ID number to copy a new chart, my previous charts already copied into Powerpoint "update" themselves and look like the information is sourced from the latest item.

我现在的选择是1)一次复制和粘贴每个项目，在Powerpoint上运行我的数据标签代码，然后将幻灯片中的所有内容转换为图片.这很乏味.2)弄清楚如何在Excel中编辑数据标签，然后将其复制并粘贴为图像3)最理想的:从Excel复制未粘贴的图表并将其粘贴到PPT.这使我可以运行我的Powerpoint <10％格式代码，但取消链接也可以使我更改Excel工作表而不会弄乱当前的图表.

My options right now are 1) Copying and Pasting each item one at a time, running my Data label code on Powerpoint, and then converting everything in that slide into a Picture. This is tedious. 2) Figuring out how to edit Data labels within Excel, and then copying and pasting as an image 3) MOST IDEAL: copy and paste an unlinked chart from Excel to PPT. This allows me to run my Powerpoint <10% formatting code, but the unlinking also allows me to change my excel sheet without messing up my current charts.

有人知道如何将未链接的图表从Excel复制并粘贴到不是图片的PPT中吗?

Does anyone have a clue on how to copy and paste an unlinked chart from Excel to PPT that is NOT a Picture?

推荐答案

以下为您提供了可能的解决方案:

Here goes possible solution for you:

Sub Breaking_links()

Dim CHR As Shape

Set CHR = ActivePresentation.Slides(1).Shapes(3) 'for 3rd chart shape on 1st slide

CHR.Chart.ChartData.BreakLink

End Sub

简短说明-将图表复制到PP中后，您需要断开指向上面示例所示的数据源的链接.

Short explanation- after you copy a chart into PP you need to break link to data source which present above example.

此外，我认为您可以像在PP中一样轻松地在Excel中修改轴.如果您发现该选项更好，请向我们显示您的PP代码，这将有助于为您提供一些有关Excel的提示.

Moreover, I think you could modify your axis in Excel as easy as you do in PP. If you found that option better please show us your code for PP which would be helpful to provide you some tips for Excel.

这篇关于将未链接的Excel图表粘贴到Powerpoint的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！