<div>
The simplest way is to put your data in a Table (using the Insert...Table ribbon item). You may then filter the Table by date and the chart (which starts by including all your data) will automatically display only the visible rows.
</div>


<div>
Yes that will work but it makes it so i am always filtering the table. When you are collecting the blood pressure data twice a day for a year that could be a pain.<br><br>Couldn't it be done with some sort of vlookup or something?
</div>


<div>
I could also do it with dynamic named ranges, or with a formula that copies a subset of your data over to a new range of cells that actually gets plotted.<br><br>If you have Microsoft 365 subscription, I could use the FILTER function for this latter purpose.
</div>


<div>
Another option (if you are familiar with Power Query), is to use something like the attached. &nbsp;Changing the DateRange, and then right-clicking the Result will update the Chart.<br><br><a href="https://filedb.experts-exchange.com/incoming/2021/07_w28/1565599/EE.xlsx" rel="ugc">EE.xlsx</a>
</div>


EE.xlsx

<div>
I created named ranges for StartDate, EndDate, PlotDates, PlotSystolic, PlotDiastolic, PlotHeartRate. I could then change the series to use 'Blood Pressure'!PlotDates for the range of dates.<br><br><a href="https://filedb.experts-exchange.com/incoming/2021/07_w28/1565601/Health-and-Fitness-Tracker-v1a.xlsx" rel="ugc">Health-and-Fitness-Tracker-v1a.xlsx</a>
</div>


Health-and-Fitness-Tracker-v1a.xlsx

Network Administrator

Mark Wood

<div>
Please let me know if you want me to delete the sample file from my post.
</div>


<div>
It is easy if you are willing to use vba. &nbsp;The filtering is automatically applied whenever you change the start date or end date in the dashboard,<br><a href="https://filedb.experts-exchange.com/incoming/2021/07_w28/1565621/filter-blood-pressure-by-date.xlsm" rel="ugc">filter blood pressure by date.xlsm</a><br><br><pre><code class="code-10 nolinks" id="code-20-43311155-1"><span>Option Explicit</span>
<span></span>
<span>Private Sub Worksheet_Activate()</span>
<span>&nbsp; &nbsp; Call filterBloodPressure</span>
<span>End Sub</span>
<span></span>
<span>Private Sub Worksheet_Change(ByVal Target As Range)</span>
<span>If Not Intersect(Target, [k5,m5]) Is Nothing Then Call filterBloodPressure</span>
<span>End Sub</span>
<span></span>
<span>Sub filterBloodPressure()</span>
<span>&nbsp; &nbsp; Sheets("Blood Pressure").ListObjects("Table2").Range.AutoFilter Field:=2, Criteria1:= _</span>
<span>&nbsp; &nbsp; &nbsp; &nbsp; "&gt;=" &amp; [k5], Operator:=xlAnd, Criteria2:="&lt;=" &amp; [m5]</span>
<span>End Sub</span>
<span></span>
<span></span>
</code></pre>
</div>


filter-blood-pressure-by-date.xlsm

<div>
Data is already in a Table but don't need to have all the blank rows ready for data, the table will expand as required.<br><br>You can also use a Pivot Chart linked to a Pivot Table to display the data, the filter options are then on the chart rather than having to filter elsewhere.<br><br>See attached, I have reduced the rows in the Table to only those used and inserted a Pivot Table and Chart. The Pivot Table is linked to the data Table so will include all new data when added but will need a refresh.<br><br><a href="https://filedb.experts-exchange.com/incoming/2021/07_w28/1565646/Health-and-Fitness-Tracker-v1a.xlsx" rel="ugc">Health-and-Fitness-Tracker-v1a.xlsx</a>
</div>


Consultant

Robert Berke

<div>
I see two ways to realize that ...<ol><li>I've done a similar task with charting part of a big heap of temperature data. I've just stuffed the complete data into the diagram and just changed the X-axis limits. With real much data it gets a bit slow, but it works. Unfortunately there's no way to let the Xmin and Xmax settings of a chart be determined by pointing excel to da field, but I've managed that with some macro (this is for several charts, and works with acceptable speed on about 650.000 lines of data):<pre><code class="code-10 nolinks" id="code-20-43311596-1"><span>Sub ScaleAxes()</span>
<span>&nbsp;&nbsp;&nbsp;Dim x As Chart</span>
<span>&nbsp;&nbsp;&nbsp;Dim xa As Axis</span>
<span>&nbsp;&nbsp;&nbsp;Dim s As Worksheet</span>
<span></span>
<span>&nbsp;&nbsp;&nbsp;For Each x In ActiveWorkbook.Charts</span>
<span>&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;For Each xa In x.Axes</span>
<span>&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Select Case xa.Type</span>
<span>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Case xlCategory</span>
<span>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; xa.MinimumScaleIsAuto = False</span>
<span>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; xa.MaximumScaleIsAuto = False</span>
<span>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; xa.MaximumScale = CDbl(CDate(Sheets("Data").Range("I2").Value))</span>
<span>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; xa.MinimumScale = CDbl(CDate(Sheets("Data").Range("I1").Value))</span>
<span>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Case Else</span>
<span>&nbsp; &nbsp; &nbsp; &nbsp; End Select</span>
<span>&nbsp; &nbsp; &nbsp;&nbsp;Next xa</span>
<span>&nbsp;&nbsp;&nbsp;Next x</span>
<span>End Sub</span>
</code></pre></li><li>Create a new worksheet, the use the database query feature pointing to the full data worksheet as database (maybe you need to use a second excel workbook as data miner). Use SQL or some other query mechanism to filter for anything you desire. Use the query result as data source for your chart.</li></ol>
</div>


<div>
<div class="content wysiwyg-content fr-view">
I have a spreadsheet where i am wanting to track blood pressure. On sheet 1 there is a chart for the blood pressure where it pulls data from the blood pressure sheet. What i am wanting to do is use the Start Date and End Date above the chart to only pull the data from the blood pressure sheet between those dates to populate the chart.<br><br>i have added a sample spreadsheet for review.<a href="https://filedb.experts-exchange.com/incoming/2021/07_w28/1565591/Health-and-Fitness-Tracker-v1a.xlsx" rel="ugc">Health and Fitness Tracker-v1a.xlsx</a>
</div>
</div>



I have a spreadsheet where i am wanting to track blood pressure. On sheet 1 there is a chart for the blood pressure where it pulls data from the blood pressure sheet. What i am wanting to do is use the Start Date and End Date above the chart to only pull the data from the blood pressure sheet between those dates to populate the chart.
i have added a sample spreadsheet for review.
Health and Fitness Tracker-v1a.xlsx

Excel Formula Help

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.