Posts

Showing posts with the label Charts

Image Overlay Chart

Creating Image Overlay Char t The video shows how to create an overlay chart which is just really cool visual to create in addition to a waterfall chart Use 100% Stacked Column Swap Rows & Columns No Fill for $ Remaining Couple more edits like shrinking width, removing title, and bottom x axis, highlight $ raised/billed to red fill Move image behind opaque thermometer

Waterfall Charts Version 2

I made a Version 2 of the Waterfall chart and provided an example that goes from Jan through Dec.  In addition, I think it was helpful to have a bar in the waterfall chart to show bill YTD. From left to right, it is the ATB amount, Bill YTD amount, billing for each month, and finally the remaining to bill. With so many budgets and billings throughout the month, the waterfall chart is a great visualization tool to understand if we are on track regarding that ATB.

Waterfall Charts

Waterfall Charts I made a waterfall chart for a specific ATB estimate with made up ATB amounts and numbers. The starting amount is in green and each red bar represents a particular month's billing and the yellow shows remaining amount to bill. It is a great visualization to see if we are on track billing up to the ATB amount or behind or even over.