Stacked Chart with 2 values

[Paiman]

Hi Everyone,

I need help on how to create a stacked chart with 2 values? here's my sample of data, right now my stacked chart only show the stacked "hedge", I want the "Open" included

Hedge = will have varied stack

Open = will have 1 stack, because it only has data at the end of each risk_month

I've read several articles related with this, but mines a bit different, no? much appreciated for the help

commodity	RecommOrNot	trading_date	risk_month	Calc_Hedge3	Calc_Open4
BTC	Recommended	11/30/2018	1/1/2020	1,041.80
BTC	Recommended	12/28/2018	1/1/2020	1,833.60
BTC	Recommended	1/25/2019	1/1/2020	4,028.70
BTC	Recommended	2/22/2019	1/1/2020	7,359.10
BTC	Recommended	3/29/2019	1/1/2020	16,126.50
BTC	Recommended	4/26/2019	1/1/2020	21,114.60
BTC	Recommended	5/31/2019	1/1/2020	53,049.00
BTC	Recommended	6/28/2019	1/1/2020	193,824.90
BTC	Recommended	7/26/2019	1/1/2020	217,778.60
BTC	Recommended	8/30/2019	1/1/2020	866,210.20
BTC	Recommended	9/27/2019	1/1/2020	3,886,171.60
BTC	Recommended	10/25/2019	1/1/2020	9,763,235.90	236,764.10

[mahoneypat]

Do you need Open to be a separate stack?  If not, you can just use a measure like (replace Table with your actual table name).

NewMeasure = SUMX(Table, Table[Calc_Hedge3] + Table[Calc_Open4])

If so, you'll likely need to use the new Charticulator visual to make your desired chart.

(9) Season 1 - Charticulator - YouTube

Pat