How should we show the “overall” or “average” data on bar charts — in addition to the subgroups? You’ll see two options: (1) Add a column, or (2) Add a line. You can download my Excel template, too.