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.
Bookmarks