+ Reply to Thread
Results 1 to 2 of 2

Chart isn't updating - "SelectSourceData" issues

  1. 10-16-2015, 03:35 PM #1
    ChrisHook
    ChrisHook is offline
    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
    Reply With QuoteRegister To Reply
  2. 10-17-2015, 05:15 AM #2
    Jacc
    Jacc is offline
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,871

    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 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. 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. Don't know the Forumlas with problem either using "vlookup" "if" "and" or "index" "match"
    By Jokeman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  3. [SOLVED] Data labels are "behind" shape that is part of the chart. How do I "bring them to front"?
    By cougar300 in forum Excel Charting & Pivots
    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. Pivot Chart: Adding "Projection" bar above "actual" bar for current quarter results
    By dks345 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-17-2012, 01:17 PM
  6. Copying chart: "Paste as picture" works but "Paste as link" links to wrong chart
    By 6StringJazzer in forum Excel General
    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. Chart "Connect data points with line" for "Hidden and empty cells"
    By Suni in forum Excel Charting & Pivots
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1