Asset Activity Graph

[Remingtonr]

I'm trying to create a graph. I can calculate the days of inactivity based on a "last active date". I have an asset number and a date the asset activity was measured. I want to measure the asset over time every ~7 days. The asset might sit for 90 days before being used and the measured activity date would recalculate to say active within the last 5 days at the next measurement. So you might have something like:

A1:Asset number B1:6 C1:13 D1:20 etc J1:85 KI:3

Of course dates associated with each measurement. Box and whisper doesn't seem to fit this graph but might be able to work. The point of the graph is to point out assets as they sit without being used. There are approximately 1500 assets to measure. Any suggestions?

Thanks,
Rem