Excel Magic Trick 1221


Dynamic Chart to Plot Daily Changes in Meter Readings

DESCRIPTION

Learn how to create a dynamic chart that updates when daily meter readings are entered into a table
(00:10) Problem Setup
(00:50) IF function and ISNUMBER Function to remove huge minus number from chart
(05:34) Excel Table feature to create dynamic Chart. Automatically Add New Daily Records To Chart.

WORKBOOKS