PDA

View Full Version : [SOLVED] Stack bar chart configuration in Excel



volabos
05-02-2017, 09:43 AM
Hi,

I have posted this issue in some other forum, however unable to get any reply. Hoping someone here would help me out.

I have created a stack bar chart pair, as in the attached Workbook. Now I want to reduce the gap/distance between 2 columns, i.e. want to make 2 bars closer to each other. However the width of individual column/bar should not be changed.

Can somebody give me a pointer how to do that. Any help will be highly appreciated.

I am using Excel version 15.21.1

Thanks for your time.

***Previously I forgot to attach the Workbook, now it should be visible.

mdmackillop
05-02-2017, 02:30 PM
By cheating; add a blank column

volabos
05-02-2017, 04:39 PM
Elegant solution. Thanks,