Tracking expiration dates with bar charts
This is a nice way to inventory memberships, patents, or information that has a shelf life. We've included a download for you to review, but there's really no trick to setting this up; just format the X axis as dates. The X axis automatically chose to plot dates every 3 years. You will need to format the Y axis to show "Categories in reverse order" if you want to plot them in the datasheet as shown below. Otherwise Patent 1 will be a the bottom of the axis.