Excel Effects

Bar with average line chart – Show values from top to bottom.

Bar with average line chart

Bar with average line chart

In a bar with average line chart, the categories are shown from top to bottom or vice versa. Overall, it is not that difficult to create. However, when you try to add an average line, that is when things get tricky. Also, notice how we have the categories in descending order. Now, if we were dealing with dates or categories that present a certain order, then we could not do that.

Requirements

Excel 2007 or higher or compatible.

Download


Chart library

Development Category (English)300x250

Microsoft Surface Book 3

Microsoft