xy scatter with picable dates

[dmheller]

All,
I have an xy scatter with dates up to a year with minute data. I want it in an xy scatter but I want to be able to pick a date range without editing the axis. Any help would be great.
thanks

 

[Worf]

Hi

One option is to get the dates from cells. Clicking a button would automatically update the chart.
You could also use a date picker control, see page below.

' sheet module
Private Sub CommandButton1_Click()
Dim c As ChartObject
Set c = Me.ChartObjects("chart 2")
c.Chart.Axes(xlCategory).MinimumScale = [d15]
c.Chart.Axes(xlCategory).MaximumScale = [d16]
End Sub

https://www.ablebits.com/office-addins-blog/2016/10/12/insert-calendar-excel-datepicker-template/