hi all,

friend sent me a sample gambling simulator sheet

the cell V12 can be changed such that the number of samples is dynamic

somehow the existing series' in the chart are also dynamic with this, but when i try to add a new series (eg column M), it maps all the redundant zeros and is not dynamic

how can i add new series in the same xlsb dynamic format like the existing 3?

HELP! thanks!


varianceSim6.xlsb