Is it possible to write code in excel that sums specific records from a
dataset (worksheet) based on date ranges, employee name, etc. That data
would then be automatically charted on a graph. I'm experienced with Excel
and am an experienced programmer; I've just never programmed in Excel.

If this type of work is possible can somebody show me where I can find
examples to learn by?

Thanks a bunch!