Decrease the gap between bars in Bar Chart

Decrease the gap between bars in Bar Chart

Post by Ramanjaneya Redd » Thu, 08 Sep 2011 12:45:33



Is there any way to decrease the gap between bars (NOT the width of the
bars) of excel bar chart?
I made a bar chart with 23 dates (weeks like 10/5/2007, 10/12/2007,
10/19/2007 etc.). The row were very thin and the gap between the rows is
long. Can we decrease the gap between the bars to make it look good?

Thanks in advance...

Regards,
Ramanjaneya

 
 
 

Decrease the gap between bars in Bar Chart

Post by dguillett » Fri, 09 Sep 2011 00:35:27


Change the AXES to category. You dont say which version but in 2003 right click the chart and select

From: Ramanjaneya Reddy
Sent: Tuesday, September 06, 2011 10:45 PM

Subject: $$Excel-Macros$$ Decrease the gap between bars in Bar Chart

Is there any way to decrease the gap between bars (NOT the width of the bars) of excel bar chart?
I made a bar chart with 23 dates (weeks like 10/5/2007, 10/12/2007, 10/19/2007 etc.). The row were very thin and the gap between the rows is long. Can we decrease the gap between the bars to make it look good?

Thanks in advance...

Regards,
Ramanjaneya
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip

3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com


<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel