Forum Discussion
milihramba
Jun 20, 2024Copper Contributor
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...
SergeiBaklan
Jun 21, 2024Diamond Contributor
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.
milihramba
Jun 24, 2024Copper Contributor
Thank you so much for your response. This is very helpful. I will play with it.
Regards,
Barb
Regards,
Barb