+ Reply to Thread
Results 1 to 3 of 3

Renaming Chart or Table shapes in PowerPoint

  1. #1
    Registered User
    Join Date
    12-18-2012
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010
    Posts
    55

    Renaming Chart or Table shapes in PowerPoint

    Hi,

    Below macro gives each chart or table a unique name (mychart1... mychart2...) in the entire PowerPoint deck.

    However, can someone modify it so that it should restart on every slide. For example on 1st slide there are two charts... so it should be mychart1 & mychart2, on 2nd slides again it should start with mychart1 and so on.

    Please Login or Register  to view this content.
    Thanks,
    Charm

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,410

    Re: Renaming Chart or Table shapes in PowerPoint

    I think this should do it. You want to reset the i on every page - so move the i=1 inside the loop for the pages.

    Please Login or Register  to view this content.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    12-18-2012
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010
    Posts
    55

    Re: Renaming Chart or Table shapes in PowerPoint

    Many Thanks, dflak
    It is working as required.

    Thanks again.

+ 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. Working with Shapes and PowerPoint
    By swayp11 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2016, 01:40 PM
  2. Centering shapes on slide when copying from excel to powerpoint
    By beaks in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-11-2016, 12:06 PM
  3. Excel/PowerPoint VBA teaser: How to change data labels in PowerPoint chart by VBA?
    By lukelucky in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-12-2015, 11:47 AM
  4. [SOLVED] Renaming a Embeded obj in powerpoint
    By Varun13 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-29-2013, 09:34 AM
  5. Replies: 4
    Last Post: 02-01-2013, 12:00 PM
  6. Controlling Powerpoint Shapes
    By Ac3Dc3 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2011, 06:16 PM
  7. Display Pivot Table Chart in Powerpoint
    By wengyee in forum Excel General
    Replies: 1
    Last Post: 03-08-2005, 11:06 AM

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