Chart In Excel

Naresh Patel
Naresh Patel used Ask the Experts™
on
Hi Experts,

this is continuation of my previous question.
one more thing to ask do we have separate check box for each line. Which invisible red and blue lines as we checked? let me tell you one thing why I want this as I am finding best fit blue line for stock trading  down to up and red line for best fit line from stock price up to down ....possible ? and now don't required "aaa 10 bbb" and ccc 20 ddd" as in scroll bar you added is giving all  information which we required.

See attached

Thanks
Chart-In-Excel--1a.xlsm
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Awarded 2010
Commented:
Hello,

I added two check boxes to the chart sheet. Their values are saved in the underlying cells N2 and P2. These cells have been formatted with custom format ;;; so the value is not visible. N2 has the range name BlueLineCheck and P2 has the range name RedLineCheck

I changed the dynamic range names for the two line series to

=IF(BlueLineCheck,OFFSET(chtLabels,0,6),0)

and

=IF(RedLineCheck,OFFSET(chtLabels,0,7),0)

which means when the box is not ticked, the cell value will be FALSE and the formula will return a 0, so no line is rendered.

Let me know how you get on.

cheers, teylyn
Chart-In-Excel--2a.xlsm
Naresh PatelFinancial Adviser

Author

Commented:
I Am Your Fan.
Naresh PatelFinancial Adviser

Author

Commented:
Let Me Know How Do I Delete This Heading ?Heading Mam you did perfect but now buttons explains every thing so no requirement of same information.

And I seen your post on Fibonacci clock in Excel on EE as Well as on your site. for me I have to research more to understand the concept seems quite interesting . I use Fibonacci  in my stock trading.

Thanks
Most Valuable Expert 2011
Awarded 2010

Commented:
Hi, that's the legend. Unprotect the sheet, then click the legend once, so you see a bounding box around it. Then hit the Del key on your keyboard.

The Fibonacci clock in Excel is just a little fun exercise with formulas and conditional formatting. Glad you like it.

cheers, teylyn

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial