1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to Embed Linked Values in a Chart?

Discussion in 'Discuss Data Visualizations and Charting' started by Laura Marshall, May 8, 2018.

  1. Laura Marshall

    Laura Marshall New Member

    Messages:
    2
    upload_2018-5-8_15-21-23.png

    I am trying to embed the Summary Section - it will not copy/link to PowerPoint or even group? Is there a better way to do this. These are linked to cells in the workbook so will update when values update.


    ▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !

  2. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,568
    Laura

    Firstly, Welcome to the Chandoo.org Forums

    If the objects are inside the Chart as opposed to infront of the chart I would select the Chart
    Goto the Home Tab and select the small drop down next to Copy
    Copy as Picture
    Paste into PP

    If the Text Boxes are in front of the chart
    Select the cells behind the Chart
    Goto the Home Tab and select the small drop down next to Copy
    Copy as Picture
    Paste into PP
  3. Laura Marshall

    Laura Marshall New Member

    Messages:
    2
    Hi Hui,

    The only issue is that I'm trying to have the Charts linked in PPT - so that when I update the report each week I can "automajically" update all of the charts - there are about 50 charts.

    So I guess what I need isn't really possible...
  4. Dr. Demento

    Dr. Demento Member

    Messages:
    45
    Laura,

    Unless I'm misunderstanding, a chart can be copied/linked between Excel and Powerpoint as well as an individual (or group) of cells (your summary).

    After you copy the chart/cells in Excel, use the small down arrow below the Paste in Powerpoint. Click Paste Special. Click the Paste Link radio button and choose MS Excel Chart Object for either chart or cells. Voila!

    Your summary section will need to be pre-formatted in Excel prior to pasting. That includes using a white background (otherwise you'll see the grid lines), any font/color/outline formatting, etc.

    This article highlights the differences between pasting techniques and the pros/cons. https://www.thinkoutsidetheslide.co...ally-update-when-the-excel-worksheet-changes/

    hth

Share This Page