+ Reply to Thread
Results 1 to 4 of 4

Chart Objects

  1. #1
    Forum Contributor
    Join Date
    02-26-2012
    Location
    Ottawa, ON
    MS-Off Ver
    Excel 2007
    Posts
    129

    Chart Objects

    Hello! I was wondering if there is (there must be) a way to delete a chart in a spreadsheet only if it has a certain title? There will be other charts on the spreadsheets with different titles.

    Is there a simple way to do this using Chart Objects?

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Chart Objects

    You can loop all the charts within a worksheet then delete chart based on chart label title

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    02-26-2012
    Location
    Ottawa, ON
    MS-Off Ver
    Excel 2007
    Posts
    129

    Re: Chart Objects

    Thank you!

    However, it is still deleting the charts. I have three different buttons to make three different histograms. If I click one button, I'd like it to only delete the old histogram from that button....

  4. #4
    Forum Contributor
    Join Date
    02-26-2012
    Location
    Ottawa, ON
    MS-Off Ver
    Excel 2007
    Posts
    129

    Re: Chart Objects

    Actually, no it isn't deleting them! It is moving them all to the same locations on top each other?

    Here is my code, the code is basically the same from the two other buttons but with different chart locations.

    Please Login or Register  to view this content.

+ 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. Rotating Chart Objects
    By MAMC84 in forum Excel General
    Replies: 1
    Last Post: 04-08-2008, 10:51 AM
  2. How to Name Chart Objects
    By DCSwearingen in forum Excel General
    Replies: 2
    Last Post: 07-30-2006, 05:27 AM
  3. Chart Objects Error
    By Bill in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-14-2005, 01:05 AM
  4. [SOLVED] Chart Objects
    By Bill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2005, 09:05 AM
  5. Protecting chart objects
    By julia.stone@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-18-2005, 09: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