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).
Bookmarks