65512

Paste Unlinked Excel Chart to Powerpoint

Question:

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.

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.

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.

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

Answer1:

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

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

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.

Recommend

  • verticalAlign ignored for non 0 rotation
  • Highcharts - areaspline with negative values, area should be always at the bottom
  • gvim Windows 7 netrw open url under text cursor
  • Delete pictures in PowerPoint using VBA macro
  • Highcharts not rendering in internet explorer
  • Cropping an image in Powerpoint using VBA
  • how to convert JSONString to Javascript Object
  • Plotting to a file from a function in R
  • Neo4j: Legacy Indexes and auto index vs new label bases schema indexes
  • PyQt4 application on Windows is crashing on exit
  • Emacs lua-mode issue: (void-function interactively-called-p)
  • Want to understand iframe breakout code
  • Activation Function choice for Neural network
  • Most efficient way to move table rows from one table to another
  • std::remove_copy_if_ valgrind bytes in block are possibly lost in loss record
  • Run multiple queries from 1 SQL file showing result in multiple tables
  • Xcode 4 NSLog Macro link in Xcode 3
  • Functions in global context
  • Breeze - Deleted Items nav properties bug
  • Adding a button at the bottom of a table view
  • Getting last autonumber in access
  • javaw.exe and eclipse startup problems
  • How to model a transition system with SPIN
  • How to make Safari send if-modified-since header?
  • Delete MySQLi record without showing the id in the URL
  • GridView Sorting works once only
  • XCode can't find symbols for a specific iOS library/framework project
  • How to pass list parameters for each object using Spring MVC?
  • Rails 2: use form_for to build a form covering multiple objects of the same class
  • Acquiring multiple attributes from .xml file in c#
  • How to CLICK on IE download dialog box i.e.(Open, Save, Save As…)
  • Setting background image for body element in xhtml (for different monitors and resolutions)
  • need help with bizarre java.net.HttpURLConnection behavior
  • IndexOutOfRangeException on multidimensional array despite using GetLength check
  • How can I remove ASP.NET Designer.cs files?
  • JaxB to read class hierarchy
  • costura.fody for a dll that references another dll
  • Observable and ngFor in Angular 2
  • UserPrincipal.Current returns apppool on IIS
  • java string with new operator and a literal