New York, New Jersey/USA
Experience: Intermediate
Platform: NinjaTrader
Trading: Futures
Posts: 161 since Jan 2013
Thanks Given: 63
Thanks Received: 274
|
I am creating a spreadsheet to track my trading system performance. At this point it just reproduces the NT7 "Account Performance" summary, without the bugs and miscalculations but I will add more to it as I need it.
The spreadsheet is about done but I am not happy with the fact that I have a bunch of performance charts on one sheet making it look cluttered. I am looking for a way to either show or hide a chart in a sheet based on the value of a cell which is a dropdown list. Then I can overlay all the charts on top of each other and select the chart I want from the dropdown list.
I am pretty sure this can be done in excel (or openoffice which I am using) but I am not very good at spreadsheets and cannot find how even with a google search. Any tips are welcome and appreciated.
Thanks
|