Please see attached doc.
Is there a way of creating for example an option box for this graph so i can choose what lines i want to look at? For example i just want to look at 2007 and 2009, is the check box function available for me to use for this?
Help greatly appreciated,
Thanks
You can start reading this http://www.peltiertech.com/Excel/Charts/Dynamics.html
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
Look here:
Book1(1).xls
Now you have two options:
1) IF values in your table are calculated from somewhere instead of formula you can put =IF(A6=TRUE(), formula, "")
2) if you enter values manualy you need to create some macro that will take it only if this is true
(Of course, font in A column make white so you don't see those TRUE/FALSE)
"Relax. What is mind? No matter. What is matter? Never mind!"
Thanks for the reply rwgrietveld!
I have had a look at that link you gave me and also found this
http://peltiertech.com/Excel/Charts/ChartByControl.html
I am not finding this easy to follow, could you help me out here please?
See attached.
The graph on sheet 3 is what I am looking for help on. there are 3 check boxes where if you click them on click them the series line will appear/disappear on the graph. Which is what i want, I want to add another check box so when you click that all three lines appear/disappear. How can i incorporate that?
Many thanks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks