Results 1 to 2 of 2

Macro buttons to create historical charts by month of minute-interval data

Threaded View

  1. #1
    Registered User
    Join Date
    04-17-2014
    Location
    Ireland
    MS-Off Ver
    Excel 2016
    Posts
    33

    Macro buttons to create historical charts by month of minute-interval data

    Hi.
    I think (or perhaps hope) this type of question may have been raised before, so a link to a solution would be great.
    I have around ten Workbooks of historical data but only containing between five and 14 months of data each. However, the time interval is only one minute between records, so 30 days of data involves 43,200 data points (per series) and 365 days contains 525,600 data points.
    I would like to create a macro button for each month, so if there are six months of data e.g. from mid-December 2016 to some arbitrary date in May 2017, there would be six working macro buttons, one for each month. The button would produce an X-Y Scatter chart, plotting the B, C and D columns of data against the time-stamp data, in column A, for the specified Month.
    See the attached file showing an example of a chart produced when pressing the December 2016 macro button. The existing chart could be deleted once a new macro button was pressed but this is not essential (I could just delete it when finished).
    Since there are so many data points per chart I would like the Marker size = 2 and the Line size = 0.75, but I could do this by hand.
    The labeling of chart Title and Axes, and display of the Legend would be great, but not essential.

    Is this too much to ask? Apologies if so.

    Note: I had to drastically delete rows from worksheet to be able to upload. Original sheet had data from May 2016 to May 2017 (around 520,000 rows).
    Attached Files Attached Files
    Last edited by GeoffH1; 05-21-2017 at 04:05 PM. Reason: Explain small file size

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA - Create 15 minute interval bases on start and enddate input
    By Boskant in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-25-2016, 10:07 AM
  2. Converting 1 minute data to a chosen time interval
    By James Bowler in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-09-2016, 06:06 AM
  3. excel vba switch to all sheets after interval of 1 minute
    By cpramesh in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-26-2014, 01:59 AM
  4. Looking to convert 10 minute interval data to 15 minute interval data
    By rsporseen in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-03-2013, 01:01 PM
  5. Daily Tracking sheet with 15 minute interval
    By raghavbhagat in forum Excel General
    Replies: 0
    Last Post: 09-30-2013, 07:25 AM
  6. Making a time (15 Minute) interval exclusive
    By gottabarra in forum Excel General
    Replies: 4
    Last Post: 05-07-2013, 11:07 AM
  7. Calculate how many records per 5 minute interval
    By riccaliolio in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-13-2011, 06:58 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