Results 1 to 4 of 4

Thread: mitchsu (2000)

  1. #1
    New Lounger
    Join Date
    Feb 2002
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    mitchsu (2000)

    Is there a way to create a waterfall chart in Excel? I know you can create one with a stacked column chart and format the bottom series to have no fill or line, but is there an easier way.

    Any help appreciated. [img]/forums/images/smilies/smile.gif[/img]

  2. #2
    Lounger
    Join Date
    Oct 2001
    Location
    Isleworth, Gtr London, England
    Posts
    28
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: mitchsu (2000)

    You've already discovered the easiest way ( and, as far as I know the only way ) to do a waterfall chart.

    Sorry, can't really say any more than that [img]/forums/images/smilies/smile.gif[/img]

    Glenn.

  3. #3
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: mitchsu (2000)

    I also needed some waterfalls charts for the project I was working on but as you said there is nothing automatic about them in Excel. I ended up using VBA to create them and was quite a challenge. My code solution basically does what you already know.

    It's a such a handy chart for financial modeling it's odd it's not a standard chart.

    Deb <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15>

  4. #4
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: mitchsu (2000)

    You can save your chart as a user-defined chart type.

    1/ Select your chart
    2/ Select Chart Type from the Chart menu
    3/ Select the Custom Type tab and click user-defined
    4/ Click Add
    5/ Set the name & description and click OK

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •