Link to home
Start Free TrialLog in
Avatar of Naresh Patel
Naresh PatelFlag for India

asked on

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

Thanks
Proper-Chart-In-Excel.xlsm
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

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.

Thanks
Rob H
Avatar of Naresh Patel

ASKER

Is It Possible Via VBA?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Mind Blowing ...Hatt's Off
Madam.teylyn,

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.User generated imageUser generated imageThank You
Hello,

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.
Noted

Thanks
Madam.Teylyn,

Need your help on this Link.

Please help me on this.

Thanks