+ Reply to Thread
Results 1 to 3 of 3

Create a line between points in Graph.

  1. #1
    Registered User
    Join Date
    08-11-2017
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2

    Create a line between points in Graph.

    Hello,

    I have an issue i have been struggling with for a year now, and it makes my work task take days instead of minutes.

    I have about 100 Excel sheets i need to edit every month so if someone could help me with this one i would be forever grateful!

    The question :

    i have a graph, and my wish is to have a macro button that when pressed, it makes a line from the top of the latest collum in the sheet to the one one year prior (example shown in the picture with purple ring)
    when a new collume comes cos i added more data, i wish to press the macro button again, to make the line then set itself again from the last collum to the one a year prior.

    even better if this were to happen automatically... but i haven't found such a function in Excel.

    i have added the file so you can download the excel file to play around with.
    any help would be very much appreciated.



    Untitled.jpg
    Attached Files Attached Files
    Last edited by Lbergo; 08-11-2017 at 08:01 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Create a line between points in Graph.

    Add another series to plot the 2 values. All other points can be #N/A. This will case the line to start from first value and end on last.
    Points in between will be interpolated.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    08-11-2017
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Create a line between points in Graph.

    You sir Andy, just made my day! i do not even know how to show my appreciation! with that going automatically the way it is, you have decreased my workload from days to a minute when i just copy paste in the newest information!

    Thank you very much!

+ 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. [SOLVED] VBA Line graph - connect data points
    By damp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-26-2016, 01:53 PM
  2. Hiding 0 value data points on line graph
    By brendangroff in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-14-2016, 04:28 PM
  3. Replies: 1
    Last Post: 08-27-2015, 01:54 AM
  4. [SOLVED] Bar & Line graph for 30 day rolling data points
    By ardent_guy in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 06-25-2014, 05:16 PM
  5. Need help drawing a line that fits three points on a graph
    By giuls21 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-28-2014, 07:15 AM
  6. Line graph with coloured points corresponding to legend
    By laurasmith2121 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-26-2011, 03:30 AM
  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

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