I have a Pivot Table with Year/Month/Status (Open/Closed) as nested categories, Dept (A/B) as series and Count of Records as Value ...
This drives a stacked column chart, which meets all requirements except ...
I want to bring the Open/Closed columns closer together within a Month, but then increase the space between Months ...
Have played with everything I can find/think of (Series Overlap, Gap Width, etc) without any joy ...
Any ideas?
Many thanks ...
This drives a stacked column chart, which meets all requirements except ...
I want to bring the Open/Closed columns closer together within a Month, but then increase the space between Months ...
Have played with everything I can find/think of (Series Overlap, Gap Width, etc) without any joy ...
Any ideas?
Many thanks ...