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
The existing series are dynamic as they are based on Named Ranges.
(how to http://www.homeandlearn.co.uk/ME//mes9p2.html)
Create a new one based on examples you already have.
BTW Few of them have #REF error- delete them.
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
thanks for your help!
You are welcome.
Please add reputation if you happy with solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
rynofrowan 
Register To Reply
Bookmarks