I am trying to create a waterfall chart using the Graph Builder platform. This is what I have so far. I now have two issues to resolve: How to change the color or any of the bars; I want the Potential and Actual bars to be blue, Loss bars to be red, and any credit bars to be green. Also, I want the labels showing in the white space to not be shown. Any help would be appreciated! Thanks!
Have you tried using Brady's Add-in for waterfall charts?
I think at its core it's using the graph builder like you are trying to do. Might save you some time.
Michael, Yes, I have tried the add-in by Brady Brady. however, there appear to be some problems; A.) There is no hot spot to save a script, so you have to regenerate the waterfall chart(s) individually every time you update the data. I have 21 charts I need to update at least twice per week. B.) You cannot copy and paste the charts to PowerPoint. When I try, I only get the grid to paste with an error message (Graphics script reported errors in log) without the bars.