Camera tool allows you to create a visual reference in an excel sheet using images that automatically update.
Use these efficient and time saving 'double click' options in Excel.
Sparklines, or 'micro-charts' are a great way to add visualization capability to tabular data without taking too much space.
This training video explains how to record and use a macro in Excel. You should be able to follow using Office 2010 through to 2019 and Office 365.