Forum Discussion
Excel Pivot Charts
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...
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.
- Thank you so much for your response. This is very helpful. I will play with it.
Regards,
Barb
