+ Reply to Thread
Results 1 to 2 of 2

Chart isn't updating - "SelectSourceData" issues

  1. #1
    Registered User
    Join Date
    10-14-2015
    Location
    East Coast
    MS-Off Ver
    2013
    Posts
    69

    Chart isn't updating - "SelectSourceData" issues

    Hi All,

    For some reason, when I try to update my line chart via VBA's "SelectSourceData" it ALWAYS omits the first line item. It says that it is in the range, but it is not showing on my multiseries line chart. I've attached an excel file, and the code i am using is below. Basically i'm making a dynamic line chart based upon the value of a vlookup cell controlled by a combobox.

    Please Login or Register  to view this content.

    Please use comments in your responses, as I am new to VBA and trying to learn! Thanks everyone
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,570

    Re: Chart isn't updating - "SelectSourceData" issues

    Select the show all option in your dropdown
    Click on one of the graphs and look at the formula bar, the rightmost number is the series number
    Use arrow up and arrow down keys to navigate to series 1 and you see there is a different formula in the formula bar

    I tried to correct the formula but it didn't work.
    Instead, just right click on the chart, Select Data, and delete series 1 then add it again. That fixed it for med.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

+ 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. If "value" then copy from "cellA" to "cellB" drag down issues
    By mrmeeks in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-18-2014, 12:34 PM
  2. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  3. Replies: 2
    Last Post: 06-25-2013, 12:43 PM
  4. [SOLVED] Problem creating Line Chart from columns "date" and "money"
    By brosef in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-05-2012, 09:01 AM
  5. Replies: 0
    Last Post: 09-17-2012, 01:17 PM
  6. Replies: 0
    Last Post: 06-08-2010, 03:27 PM
  7. ""All Day Event"" Check Box Issues
    By champs in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 04-03-2009, 07:10 AM
  8. Replies: 4
    Last Post: 02-03-2008, 05:11 PM

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