+ Reply to Thread
Results 1 to 1 of 1

Automatically update chart's look in PowerPoint to the changes(range/axis) done in Excel

  1. #1
    Registered User
    Join Date
    01-27-2022
    Location
    Fukuoka
    MS-Off Ver
    2019
    Posts
    6

    Automatically update chart's look in PowerPoint to the changes(range/axis) done in Excel

    Hello guys.

    How to automatically update chart's range/axis value in PowerPoint to the changes done in Excel?
    Basically chart in PPT should not be just based on data from Excel, but be a complete mirror the chart in Excel.(its range and shape etc.)

    Lets say:
    1. I copy/pasted chart as Linked Data to PowerPoint with the data for first 10 days.
    2. In Excel I extended the range of the chart to 20 days and also made adjustments to vertical Axis.

    3. Next I expect(want) PowerPoint chart look exactly like Excel's chart does (with the range up to 20 days and changes done to V. Axis).

    So how to automatically refresh chart in PPT to the current chart's state in Excel file?

    Is it something difficult to achieve?
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by AlexinJap; 02-04-2022 at 05:11 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Update Charts on Powerpoint from Excel Automatically
    By excelxzzx in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-22-2019, 11:05 AM
  2. Replies: 1
    Last Post: 06-09-2017, 02:04 AM
  3. Excel 2013. Automatically update chart range
    By kbdb in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-13-2016, 02:49 PM
  4. [SOLVED] Chart X-Axis Range Automatically Expanding With Selected Y-Axis Range
    By Mvaldesi in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 10-08-2015, 03:43 PM
  5. Replies: 5
    Last Post: 11-22-2011, 02:03 PM
  6. Excel Chart Axis Auto-Update based on cells with calculated range
    By jgray in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-29-2010, 03:50 PM
  7. [SOLVED] How do I automatically update a chart range in Excel
    By Quinton in forum Excel General
    Replies: 1
    Last Post: 07-27-2005, 07:57 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1