Chart In Excel

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
LVL 8
Naresh PatelFinancial AdviserAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Naresh PatelFinancial AdviserAuthor Commented:
I Am Your Fan.
Naresh PatelFinancial AdviserAuthor 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
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.