I am trying to create a pivot chart which represents two mutually exclusive averages. 

1. Average number of days it takes a report to get to department “A” (QRB).

2. Average number of days it takes that same report to get to department “B”(EA-1).  

I do NOT want to show it in a “Column” graph. (This is how I currently have it – see below)

I DO want to show it in a “Stacked” graph, however, I do NOT want the two averages added together.  

For example, if the average number of days to department “A” = 47 and the average number of days to department B = 66.

I do not want to add 47 + 66.  

The cummulative number of days in the report process is 66 (not 113).

I would like the bar in the stacked graph to reflect 66 against the vertical axis.  

Any suggestions would be greatly appreciated!

​I am trying to create a pivot chart which represents two mutually exclusive averages. 1. Average number of days it takes a report to get to department “A” (QRB).2. Average number of days it takes that same report to get to department “B”(EA-1).  I do NOT want to show it in a “Column” graph. (This is how I currently have it – see below)I DO want to show it in a “Stacked” graph, however, I do NOT want the two averages added together.  For example, if the average number of days to department “A” = 47 and the average number of days to department B = 66.I do not want to add 47 + 66.  The cummulative number of days in the report process is 66 (not 113).I would like the bar in the stacked graph to reflect 66 against the vertical axis.    Any suggestions would be greatly appreciated!  Read More

​