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

This is what I use. Hope it helps.

Interactive Dashboard in Excel using Hyperlinks | Chandoo.org - Learn Microsoft Excel Online

I found this, unfortunately does not work with OpenOffice.


How to Conditionally Show or Hide Charts - Excel Chart Templates & Tutorials | Chandoo.org - Learn Microsoft Excel Online