Excel Magic Trick 1221: Dynamic Chart to Plot Daily Changes in Meter Readings

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

[OzduSoleilDATA]

Very nice! This is one of those where the solution is easy, but the strategy and organization take a bit of effort.

[ronbakker]

Hi Girvin, thanks for that, I never would of figured that one out by myself.

[Sal_A]

For big spreadsheet data, does ISNUMBER function take just as long as IFERROR or ISERROR to calculate? I would prefer using IF(B3<>"", B3-B2, "")