+ Reply to Thread
Results 1 to 2 of 2

VBA Line graph - connect data points

  1. 01-26-2016, 01:09 PM #1
    damp
    damp is offline
    Registered User
    Join Date
    04-03-2014
    Location
    Denmark
    MS-Off Ver
    Excel 2010
    Posts
    27

    VBA Line graph - connect data points

    Hi

    I need help with something i thought was quite simple. I have a line chart and want to "connect data points with lines" and not use the default "gaps" see attached file below. I can change this manually but how do you do this in vba? The macro recorder does not record anything. I can't find anything on the web! ?!

    Screen Shot 2016-01-26 at 18.05.43.png


    Thank you in advance for your reply :-)!

    Kind regards
    damp
    Reply With QuoteRegister To Reply
  2. 01-26-2016, 01:53 PM #2
    MrShorty
    MrShorty is offline
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: VBA Line graph - connect data points

    I'm not sure why yours did not record. When I recorded a macro, it showed up as the chart.displayblanksas property: https://msdn.microsoft.com/EN-US/lib.../ff837379.aspx using the desired constant: https://msdn.microsoft.com/EN-US/lib.../ff837631.aspx
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.
    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. excel graph - select data points on line graph and return its corresponding vaue
    By vishal KAPASI in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-27-2015, 01:54 AM
  2. Connect/disconnect separate data points in line chart?
    By goldfrapp01 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-02-2013, 07:21 AM
  3. Connect 0 points with a line
    By Jeny Jen in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-09-2010, 04:06 PM
  4. Connect points in two different series on scatter graph
    By sa02000 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-11-2009, 06:24 AM
  5. How to plot 3 data sets on the same line graph, but not connect the data?
    By marklight in forum Excel General
    Replies: 1
    Last Post: 12-16-2008, 08:44 AM
  6. connect two broken points of a graph
    By Khoshravan in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-29-2006, 09:20 PM
  7. [SOLVED] missing data points causes my line graph not to connect
    By liebw in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 09-01-2005, 08:05 AM

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