Excel Pivot Charts

Copper Contributor

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.  

 

milihramba_0-1718903796513.png

 

Any suggestions would be greatly appreciated!

3 Replies
I don't see how you might stack two amounts on top of each other, without the end result being that the height is the sum of both periods. If you want them "stacked" one in front of the other, then you have the issue where if dept A happens to have a lower value it may disappear behind the bar for dept B, depending on the plot order.

@milihramba 

Some workaround could be if create columns chart. Next generate two shapes, play with their colors and transparency. Copy shape, select series and paste. Finally overlap series.

However, that's not very readable, of only values in one series are always greater than in another.

image.png

Thank you so much for your response. This is very helpful. I will play with it.
Regards,
Barb