Series where user defines data range

bazbuyer

New Member
Joined
Dec 20, 2017
Messages
23
Office Version
2016
Hi

I am trying to plot a chart taking data from a single column on another sheet. On the same row as the data item is a date. The user inputs (on the chart sheet) a 'date from' (F3)and a 'date to' (G3)and I want the chart to display only the data between those two input dates. So in the example below the user inputs start and end of January and a series/chart is plotted using the 6 data points corresponding to those points. The chart doesn't need to show the dates as long as they plot in sequential date order (even if they are not in order on the Register). Any ideas where to begin?
Date from date to
Register 01/01/2018 31/01/2018
15/01/20180
26/01/20181
26/01/20181
29/01/20181
29/01/20182
31/01/20181
01/02/20181
02/02/20181

<tbody>
</tbody><colgroup><col><col span="3"><col span="2"></colgroup>
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Watch MrExcel Video

Forum statistics

Threads
1,099,078
Messages
5,466,480
Members
406,484
Latest member
kaksolver

This Week's Hot Topics

Top