would be great if the reference line would compute averages and dynamically change, ala tableau and microstrategy..
More and dynamic reference lines are necessary. You can kind of jury-rig it if you use the combined column-line chart, but the lines are all connected and sloped (not flat) so they look screwy.
