Spreadsheet show/hide chart? - futures io
futures io

Spreadsheet show/hide chart?

Discussion in Psychology and Money Management

    1. trending_up 1,454 views
    2. thumb_up 2 thanks given
    3. group 0 followers
    1. forum 3 posts
    2. attach_file 0 attachments

Welcome to futures io: the largest futures trading community on the planet, with well over 125,000 members
  • Genuine reviews from real traders, not fake reviews from stealth vendors
  • Quality education from leading professional traders
  • We are a friendly, helpful, and positive community
  • We do not tolerate rude behavior, trolling, or vendors advertising in posts
  • We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community.  It's free and simple.

-- Big Mike, Site Administrator

(If you already have an account, login at the top of the page)

Search this Thread

Spreadsheet show/hide chart?

(login for full post details)
  #1 (permalink)
New York, New Jersey/USA
Experience: Intermediate
Platform: NinjaTrader
Trading: Futures
Seahn's Avatar
Posts: 161 since Jan 2013
Thanks: 63 given, 272 received

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.


Started this thread Reply With Quote

Can you help answer these questions
from other members on futures io?
text block indicator that moves with price
Tradestation 10 work offline
TOS plotting horizontal line for open in renko chart
Can I connect Tradestation to Interactive Brokers?
Traders Hideout
Alternative to Mcginley Dynamic MA
Sierra Chart
Best Threads (Most Thanked)
in the last 7 days on futures io
Vinny E-Mini & Algobox Review TRADE ROOM
144 thanks
Would you share your Holy Grail?
72 thanks
47 thanks
Spoo-nalysis ES e-mini futures S&P 500
36 thanks
ApexTraderFunding.com experience and review
14 thanks
(login for full post details)
  #3 (permalink)
Experience: None
Platform: NinjaTrader
Broker: Amp/CQG
Trading: NQ
shuglu's Avatar
Posts: 71 since Jul 2012
Thanks: 312 given, 94 received

This is what I use. Hope it helps.

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

Reply With Quote
The following 2 users say Thank You to shuglu for this post:
(login for full post details)
  #4 (permalink)
New York, New Jersey/USA
Experience: Intermediate
Platform: NinjaTrader
Trading: Futures
Seahn's Avatar
Posts: 161 since Jan 2013
Thanks: 63 given, 272 received

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

Started this thread Reply With Quote

futures io Trading Community Psychology and Money Management > Spreadsheet show/hide chart?

Last Updated on March 7, 2014

Upcoming Webinars and Events

NinjaTrader Indicator Challenge!


Copyright © 2021 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada), info@futures.io
All information is for educational use only and is not investment advice.
There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
no new posts