+ Reply to Thread
Results 1 to 3 of 3

Update chart dynamically

  1. #1
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    854

    Update chart dynamically

    I have attached a sample file which I hope is self-explanatory. I want to dynamically update my chart based on the selections from radio buttons.
    Thank you in advance.
    Attached Files Attached Files
    Last edited by Aland2929; 06-06-2010 at 05:41 AM.

  2. #2
    Forum Contributor
    Join Date
    08-11-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    149

    Re: Update chart dynamically

    SUMIF will work if you use text concatenation to make unique text strings for each one. See attached.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    854

    Re: Update chart dynamically

    Quote Originally Posted by masteff View Post
    SUMIF will work if you use text concatenation to make unique text strings for each one. See attached.
    Thank you very much for your effort. It works great.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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