# Average instead of Sum for stacked bars in bar chart?

I have a bar chart. It has 5 catagories that display on a monthly basis an average for each catagory. At the top of the bar I get the Sum of each bar segement. Is there a way to get the average of the combined segments?

Example. Y = Avg([Cost]) X = Date-Month

Let's say I have a bar for 1 month and it has 5 segemtns (colors). Each segment's value is an average cost for the month for that catagory. So we have Segment 1 = 20, 2 = 15, 3 = 40, 4 = 25 and 5 = 25. At the top of the bar I get a Sum of 125. I would like to get the average of the segments which should be 25.

Thanks for any ideas!!

+ Add a Comment