Trying to improve my report presentations with better charts and graphs. What visual formats do you find most effective for showing utility bill errors to clients? I've been using basic bar charts but wondering if there are better approaches for things like demand charge corrections or rate schedule comparisons.
Visual Charts - What Works Best?
For demand charge issues, I love using line graphs showing actual demand vs billed demand over time. Makes it immediately obvious when there are meter multiplier problems or incorrect readings. Color-code the overage periods in red - very effective visual impact.
Before/after comparison charts work great for rate schedule changes. Show monthly costs under old tariff vs new tariff over a 12-month period. Include a cumulative savings line so they can see how the benefits add up. Clients love seeing that upward trending savings curve.
Pie charts for showing breakdown of total recovery by category - billing errors, demand charges, taxes, etc. Helps clients understand where the biggest problems were. I use different shades of the same color family to keep it professional looking.
For power factor issues, scatter plots work well - show PF readings vs penalties over time. Makes it clear when they started getting hit with charges and how consistently it's been a problem. Easy to identify the months that need correction.
I started using waterfall charts for showing how errors compound over time. Start with base bill amount, then show additions for each type of overbilling - demand multiplier, incorrect tariff, tax errors, etc. Really drives home how multiple small errors add up to big dollars.
Gerald, waterfall charts are brilliant for this! Priya, one tip on your line graphs - include the utility's acceptable variance bands if you know them. Shows not just that readings were wrong, but how far outside normal parameters they were. Adds credibility to the finding.
For tax-related errors, I use stacked bar charts showing base charges, correct tax amount, and overbilled tax amount. Makes it really obvious when they've been paying tax on items that should be exempt. Color the overage portion in bright red.
Don't overlook simple trend lines for showing seasonal patterns in billing errors. Had a client where meter reading errors were worse in winter months - probably access issues. The trend chart made it obvious and helped explain to the utility why certain periods needed review.
These are all excellent ideas! I'm definitely going to try the waterfall charts Gerald mentioned. Priya, what software are you using for the charts? Excel or something more specialized?