• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Waterfall chart question

juanito

juanito

Member
I made a waterfall chart following Chandoo's method: create a line chart; add up-down bars which are the waterfall; make the line disappear.


I now want to make the bars "thicker" - to reduce the gap between them. But I can't for the life of me figure out how to do this. If I go to the "format data series" I'm not given the overlap option because (I believe) Excel thinks it's a line chart so gaps between bars aren't relevant.


It's especially frustrating since it's something I once did before - but this was when I was on 2003. Any help will be much appreciated!
 
Jon recently posted short rundown of various waterfall techniques. Perhaps one of them will meet your needs?

http://peltiertech.com/WordPress/excel-waterfall-charts-bridge-charts/


I think if you use the floating column approach, you can adjust the gap width to give you the "thicker" bars.
 
Thanks for the link, Luke. In the article you refer to (which I hadn't read), Jon says:


"In Excel 2007 there is no way to change the up-down bar gap width from within the user interface, but you can do it with VBA..."


I've recently upgraded to 2007: that's why I'd managed to adjust width before but couldn't find a way to do it any more.


Problem solved: amazing, isn't it! Thanks again.
 
Got to love all the things Microsoft took away in 2007. =(


Glad you got it working. =)
 
You must log in or register to reply here.
Back
Top