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

(1) Answer

Login