Waterfall chart

[Mr2017]

Hi

I have a waterfall chart with 5 metrics.

But I'll use 2 of the metrics (see below) to simplify the question:

[TABLE="width: 272"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Baseline Sales[/TD]
[TD]Incremental Sales[/TD]
[/TR]
[TR]
[TD]10,000,000[/TD]
[TD]5,000,000[/TD]
[/TR]
</tbody>[/TABLE]

Question: when using a waterfall chart, if the baseline sales are $10m and the incremental sales are $5m, how can I get the chart to show the 'incremental' $5m from the $10m line on the axis instead of the 'incremental' $5m starting at $0 on the axis?

Your help would be greatly appreciated.

Thanks in advance.

 

[Jon Peltier]

I can't envision what you are describing.

Is it a built-in Excel 2016 waterfall chart?

If not, did you follow a protocol like this to build it?