+ Reply to Thread
Results 1 to 2 of 2

Dynamic Chart VBA data range issue

  1. #1
    Registered User
    Join Date
    04-02-2015
    Location
    London
    MS-Off Ver
    2013
    Posts
    3

    Dynamic Chart VBA data range issue

    Hi, ive used some code from a youtube video ive found and altered it to fit my data range. However, the chart is now calculating all the blank cells beneath it. I'm very new to all this and so not entirely sure what I'm doing. Any help would be greatly appreciated. Here's the code before:

    Please Login or Register  to view this content.
    And this is what I've changed as my data starts in h20, i20 and j20.

    Please Login or Register  to view this content.
    Last edited by 6StringJazzer; 04-08-2015 at 01:17 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,802

    Re: Dynamic Chart VBA data range issue

    Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

    Also, you have updated this thread to SOLVED but there are no responses to your question--can you describe what you did to solve it?
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. add excel data in body email (data range is dynamic) & signature issue
    By Marijke in forum Outlook Programming / VBA / Macros
    Replies: 3
    Last Post: 11-25-2014, 05:41 AM
  2. [SOLVED] Dynamic Named Range issue with Data Validation
    By bamaisgreat in forum Excel General
    Replies: 5
    Last Post: 11-29-2012, 02:07 PM
  3. Chart Title from Dynamic Range Issue
    By a2excel in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-10-2012, 03:41 AM
  4. Replies: 3
    Last Post: 07-29-2010, 02:27 PM
  5. Dynamic Data Range Issue
    By MackAttack26 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-12-2009, 03:55 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