Naresh Patel
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
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
ASKER
Is It Possible Via VBA?
Thanks
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Mind Blowing ...Hatt's Off
ASKER
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.
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.
ASKER
Noted
Thanks
Thanks
ASKER
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