Waterfall chart in millions but movements in thousands - chart scalling HELP!

Hello,

I have created a waterfall chart where the starting and end positions are in million.

However, the waterfall movements are in thousands. Upon creating the chart, the movements are virtually none existent in the chart.

Is there a way to adjust the scaling of the columns so that the information can be a lot more presentable?

If anybody can assist that would be most helpful

Thank you
Krishna

Data.JPG

Waterfall.JPG

Is there a way to adjust the scaling of the columns so that the information can be a lot more presentable?

There are no magic buttons anywhere in chart options that changes data (except maybe the "logarithmic axis" option, but that is not helpful here, nor is it usually advisable unless your audience knows how to read logarithmic axes).

Whenever I have seen this done, it almost always involves a second "copy" of the input data where the programmer applies the desired scaling factors to the data, and then the chart is reading from this copy of the data. I have no idea what kind of scaling factors/formulas you would want to use here, so I cannot make any specific formula recommendations. One way or another, you need to make a copy of the data with different values that the chart can use.