+ Reply to Thread
Results 1 to 3 of 3

VBA code needed for macro to produce line graph based on specified date with different n

  1. #1
    Registered User
    Join Date
    07-24-2017
    Location
    Stamford, UK
    MS-Off Ver
    2016
    Posts
    7

    VBA code needed for macro to produce line graph based on specified date with different n

    Hi there,

    I have a workbook which extracts data and splits it by day into chronological order with a corresponding result (e.g. time and blood pressure). Currently I have a worksheet produced by a macro that looks like the picture attached for 12 days. Days 1-12 take up 2 rows each throughout the rest of the worksheet: Columns A-X

    Can anybody please help me to generate a macro which would allow the user to simply select which day they would like and the macro produce one line graph for that day on a new worksheet "Results". This data is a full 24-h recording over 12 days providing 15-min averages. Some times values are missing or the monitor was not worn for the full 24-h so the xlup function would be needed here for the ranges.

    In short, the desired outcome is:
    A simple options box/tick box on the "Results" worksheet that would go into the "GraphData" worksheet and select cells with values in to produce a line graph showing changes in blood pressure over that particular day.

    I hope this all makes sense and thank you for any help you can offer!

    Telemanes

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,607

    Re: VBA code needed for macro to produce line graph based on specified date with different

    We are glad to hear you solved it on yourself. But it would be lovely if you post the solution for those, who find your thread (for instance by using https://www.excelforum.com/search.php )
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    07-24-2017
    Location
    Stamford, UK
    MS-Off Ver
    2016
    Posts
    7

    Re: VBA code needed for macro to produce line graph based on specified date with different

    Hi Kaper,

    This has not been solved, I must have accidentally marked it as such yesterday. My apologies.
    I have attached some random glucose data I have of my own that would still be the same principal. I hope my comments make sense
    Attached Files Attached Files
    Last edited by Telemanes; 08-01-2017 at 06:20 AM.

+ 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. Select custom date ranges and update line graph (Macro?)
    By Keelin in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-03-2017, 04:33 PM
  2. Select custom date ranges and update line graph (Macro?)
    By Keelin in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-03-2017, 04:30 PM
  3. Macro to select custom date ranges and update line graph
    By Keelin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-03-2017, 08:01 AM
  4. how to make line graph dynamic based on date ranges?
    By mikey42979 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-09-2016, 03:33 PM
  5. [SOLVED] code for data range selection to create a line graph in a macro
    By dominicm in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-17-2015, 09:35 AM
  6. Code for Macro for Line-Column 2 axis (y) Graph
    By jackofspades4395 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2013, 05:17 AM
  7. Replies: 1
    Last Post: 04-11-2012, 10:26 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1