W webmax Member Mar 14, 2014 #1 Hi Kindly find the attached file. i have put the bar chart but there was gap between one chart to next chart. I am try to reduct the chart using the format data series but unable to do. How to reduct the gap. kindly advise regards Shahul Attachments chartgap.xlsx 11.2 KB · Views: 10
Hi Kindly find the attached file. i have put the bar chart but there was gap between one chart to next chart. I am try to reduct the chart using the format data series but unable to do. How to reduct the gap. kindly advise regards Shahul
Debraj Excel Ninja Mar 14, 2014 #2 HI Shahil, Select any series, (Jan or Feb) Press Ctrl + 1, you can find the option called Gap Width. Adjust the GAP..
HI Shahil, Select any series, (Jan or Feb) Press Ctrl + 1, you can find the option called Gap Width. Adjust the GAP..
Smallman Excel Ninja Mar 14, 2014 #3 Webmax Right click on the blue bar and click, take the Gap width down to about 20%. The gap will be minor then. Take care Smallman
Webmax Right click on the blue bar and click, take the Gap width down to about 20%. The gap will be minor then. Take care Smallman
W webmax Member Mar 14, 2014 #4 I have already tried but the width and size is very big regards Shahul
N NARAYANK991 Excel Ninja Mar 15, 2014 #5 Hi Shahul , See this file. I am sure you can see what has been done. Narayan Attachments chartgap.xlsx 10.8 KB · Views: 8
