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.


Excel 2007 or higher or compatible.


Chart library

Great Hair Ideas customizable PowerPoint art

Development Category (English)300x250