This has worked to change our habits pretty well. For instance we now consider it “expensive” to run the dishwasher during the day. We’ll do it if necessary but there is now a mental barrier to doing so.
I agree with the note later in the thread that the solution is powerwall like things for demand smoothing / moving.
For the charts in my office I have a Prometheus/Grafana setup at home for a variety of things and built a bridge to the comed data for Prometheus (https://github.com/kklipsch/comed_exporter). For usage data I have a neat gadget called a Rainforest Automation Eagle (https://www.rainforestautomation.com/compare-emu-and-eagle/) that reads my smart meters radio signal. It exposes an xml api and I wrote a bridge to Prometheus (https://github.com/kklipsch/reagle).
Once it’s all in Prometheus the Grafana dashboards are pretty straight forward affairs.