+ Reply to Thread
Results 1 to 5 of 5

Draw a waterfall chart using VBA - make stacks transparent

  1. #1
    Registered User
    Join Date
    09-10-2010
    Location
    France
    MS-Off Ver
    Excel 2007
    Posts
    17

    Draw a waterfall chart using VBA - make stacks transparent

    Hello,

    I need VBA code to draw waterfall charts.

    I have been reading around (especially http://peltiertech.com/, this forum and http://www.ozgrid.com) but could not find what I need.

    I have written a macro (which need some polishing, especially visually) but I cannot find how to make the bottom part of the stacked columns chart invisible.

    I have tried recording the macro while doing it, but it did not show up.

    I need this code to integrate it into a larger routine which will generate several waterfall charts automatically (at least that's what I would like).

    I am attaching the code I have so far (so you can see it in action), which is almost there, the only missing bit is the transparency for the bottom stacks. I also copy the code below.

    Could anyone help? It would be MUCH appreciated

    Thank you in advance

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by NiceLittleRabbit; 03-23-2011 at 05:59 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Draw a waterfall chart using VBA - make stacks transparent

    Something like this.
    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    09-10-2010
    Location
    France
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: Draw a waterfall chart using VBA - make stacks transparent

    Thank you, Andy, it works like a charm!!!

    In case anyone is interested, here goes the corrected full code which needs to be replaced in the former attachement:

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    01-29-2012
    Location
    United Kingdom
    MS-Off Ver
    MS Office 2003/MS Office 2010
    Posts
    45

    Re: Draw a waterfall chart using VBA - make stacks transparent

    Thanks for the code

    There is a problem- i copied it to my module, but it produces errors ("Application-defined or object-defined error") on lines:
    Please Login or Register  to view this content.
    I'm very interested in gettin it work. Any ideas why it doesn't work?

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Draw a waterfall chart using VBA - make stacks transparent

    Welcome to the Forum, unfortunately:

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

    Start a new thread and post example workbook that illustrates your problem

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1