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!!