Limit the data posted in a column chart.

[DarbyBrown]

I have an excel worksheet that shows my blood pressures and heart rate. There is also a column chart on the same sheet. The problem is the more data i include in the table, the tighter the columns get. I want to limit the data in the chart to the last 14 days and allow for scrolling backwards. I would also like the chart to float down the sheet as the table gets longer. I have the chart, the axis are time and date on the horizontal plane and measurements on the vertical plane. And three columns make up a cluster, Systemic, Diastolic and Heart Rate.

Any thoughts? I have checked my Excel 2016 Bible and online to no avail. Am I looking in all the wrong places?

darby

When you were born, You cried and the world rejoiced,
Live your life so that when you die the world cries and you rejoice.
~Old Indian Proverb~

 

[Yongle]

Base your chart data on dynamic named ranges
Have a look at this tutorial from ComputerGaga

 

[DarbyBrown]

YONGLE,
SORRY IT TOOK SO LONG TO GET BACK ON THIS. LOOKS LIKE IT WILL SOLVE MY PROBLEM. i'LL GIVE IT A TRY AND LET YOU KNOW. THANKS FOR THE HELP.

 

[Jon Peltier]

Why not sort the data from newest to oldest? The latest will be at the top, the older ones will soon be "below the fold".