Hi,
Is it possible to create a waterfall chart using the Charting Tool?
I am aware that it is not one of the chart types but was wondering if anyone has found a workaround.
Thanks,
The best way to build this would be to use the R tool to generate the graphic you need. If you only want to use the Charting tool, then you can trick the user by setting the bar color the same as the background (and remove axis lines) so it doesn't appear to be there.
I've attached an example solution using the Charting tool.
Thanks @CharlieS! Your workflow is very helpful - I will play around with it and incorporate it into my workflow.
I have one more question if you don't mind - is there a way to change the numeric data in number format into percentage format on the report? Currently, I am trying to use the Table tool and format the data by column.
Thank you for your help!
Hi Charlie,
Thanks for awesome advice. But could you also please advise me how can i output the chart into an excel file? I have tried but it turns out some unique code.
