+ Reply to Thread
Results 1 to 9 of 9

Unlink Chart

  1. 07-02-2023, 08:25 AM #1
    getafixkwik
    getafixkwik is offline
    Forum Contributor
    Join Date
    04-14-2014
    Location
    Philippines
    MS-Off Ver
    2007, 2010, 2013, 2016.
    Posts
    169

    Unlink Chart

    Hi All,
    Need VBA help to unlink 2 charts (Unrelated) in sheet1.
    Thanks
    Reply With QuoteRegister To Reply
  2. 07-02-2023, 08:39 AM #2
    BadlySpelledBuoy
    BadlySpelledBuoy is offline
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    8,022

    Re: Unlink Chart

    What do you mean "unlink"?

    BSB
    Reply With QuoteRegister To Reply
  3. 07-02-2023, 08:44 AM #3
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,838

    Re: Unlink Chart

    I as about to ask a similar question: how can they be linked if they are unrelated?

    Provide a sample workbook.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  4. 07-02-2023, 10:18 AM #4
    getafixkwik
    getafixkwik is offline
    Forum Contributor
    Join Date
    04-14-2014
    Location
    Philippines
    MS-Off Ver
    2007, 2010, 2013, 2016.
    Posts
    169

    Re: Unlink Chart

    Hi
    I mean the charts unrelated to each other.
    Attaching the file now.
    Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 07-02-2023, 10:28 AM #5
    BadlySpelledBuoy
    BadlySpelledBuoy is offline
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    8,022

    Re: Unlink Chart

    You still haven't explained what you mean by "unlink". Unlink the charts from what??

    BSB
    Reply With QuoteRegister To Reply
  6. 07-02-2023, 11:03 AM #6
    getafixkwik
    getafixkwik is offline
    Forum Contributor
    Join Date
    04-14-2014
    Location
    Philippines
    MS-Off Ver
    2007, 2010, 2013, 2016.
    Posts
    169

    Re: Unlink Chart

    Hi BSD.
    Sorry, I mean to unlink from data source. just like pasting range as value.
    Chart becomes picture. There are online samples but hoping for VBA help.
    Hope I explain it well. Thanks.
    Reply With QuoteRegister To Reply
  7. 07-02-2023, 11:10 AM #7
    BadlySpelledBuoy
    BadlySpelledBuoy is offline
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    8,022

    Re: Unlink Chart

    OK. Makes much more sense now.

    Try this in a standard module:
    Please Login or Register  to view this content.
    BSB
    Reply With QuoteRegister To Reply
  8. 07-02-2023, 01:34 PM #8
    getafixkwik
    getafixkwik is offline
    Forum Contributor
    Join Date
    04-14-2014
    Location
    Philippines
    MS-Off Ver
    2007, 2010, 2013, 2016.
    Posts
    169

    Re: Unlink Chart

    BSB
    Your Code works.
    I appreciate your help so much.
    Thank You.
    Reply With QuoteRegister To Reply
  9. 07-02-2023, 01:36 PM #9
    BadlySpelledBuoy
    BadlySpelledBuoy is offline
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    8,022

    Re: Unlink Chart

    Glad I Could help

    BSB
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to unlink data
    By thunderspeed in forum Excel General
    Replies: 1
    Last Post: 10-31-2020, 11:48 AM
  2. Group Boxes Will Not Unlink
    By jumpbackjack in forum Excel General
    Replies: 1
    Last Post: 01-03-2014, 02:31 AM
  3. unlink pivot table data from chart in word
    By Phoenixgirl in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-09-2013, 12:53 AM
  4. How to UNLINK cells
    By djerey in forum Excel General
    Replies: 2
    Last Post: 02-01-2012, 05:42 PM
  5. [SOLVED] unlink object
    By Chuck in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-09-2006, 08:59 AM
  6. [SOLVED] Unlink a file ??
    By Kane in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 02-05-2006, 04:10 PM
  7. Unlink Sheets
    By Audubon in forum Excel General
    Replies: 0
    Last Post: 02-04-2005, 03:18 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1