Chart In Excel

Hi Experts,

I have one Macro Enabled WB. In their there is 2 sheets viz Data - Chart.
Need to implement in chart sheet
Need to see whole sheet as chart area and controls & buttons on chart area. Not required any text from controls and buttons ..just simply buttons.  is that possible? so sheet chart shows me whole as chart and only buttons which zooms & Scrolls

See attached

Naresh PatelFinancial AdviserAsked:
Who is Participating?

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

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.

Rob HensonFinance AnalystCommented:
I do not believe that is possible.

You can right click on the Chart and Select "Move Chart..." to move it to a Chart sheet but this will only move the chart and not the buttons.

I have then been able to Copy and paste the buttons from the ordinary sheet onto the chart sheet but only seem to see one.

Rob H
Naresh PatelFinancial AdviserAuthor Commented:
Is It Possible Via VBA?

Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
I'm with Rob on this one. A chart sheet can not contain the form controls.

But you could unlock the cells with the numbers, then hide the columns with the numbers and text, arrange the controls and the chart, hide the column headers and gridlines and then protect the sheet.

Amend the code that gets triggered by the buttons to this:

Sub SetYAxisMinimum()
Dim ws As Worksheet

Set ws = ThisWorkbook.Worksheets("Chart")
'this sets the Y axis minimum value on the upper chart
ws.ChartObjects("Chart 1").Chart.Axes(xlValue).MinimumScale = Range("chtYMinimum")

End Sub

Open in new window

I tried to protect with the UserInterfaceOnly option, but some things like changing the chart axis still won't work that way, so I'm going the long way: unprotect, make the change, protect again.

See attached, saved in XL 2010.

cheers, teylyn

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
CompTIA Security+

Learn the essential functions of CompTIA Security+, which establishes the core knowledge required of any cybersecurity role and leads professionals into intermediate-level cybersecurity jobs.

Naresh PatelFinancial AdviserAuthor Commented:
Mind Blowing ...Hatt's Off
Naresh PatelFinancial AdviserAuthor Commented:

Only one question how do I set chart window to see all information as in current setting I cant see horizontal axis ...and I guess whole thing is locked ...I had set zoom to 70% and I can see whole data ....but chart window contracted.Cant See Horizontal AxisSee whole data but chart contractedThank You
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:

You can unprotect the sheet (Review ribbon > Unprotect sheet), then manually resize the chart to fit on your screen. As soon as you click one of the sliders, the sheet will be protected again.
Naresh PatelFinancial AdviserAuthor Commented:

Naresh PatelFinancial AdviserAuthor Commented:

Need your help on this Link.

Please help me on this.

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.