You can devide your values by 1,000 or 1,000,000
Other way is you can use Waterfall Chart Studio Excel add-in Waterfall Chart Studio
By the way, waterfall charts become the standard type in Excel...