• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 320
  • Last Modified:

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
0
Naresh Patel
Asked:
Naresh Patel
  • 5
  • 2
1 Solution
 
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.

Thanks
Rob H
0
 
Naresh PatelTraderAuthor Commented:
Is It Possible Via VBA?

Thanks
0
 
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")
ws.Unprotect
'this sets the Y axis minimum value on the upper chart
ws.ChartObjects("Chart 1").Chart.Axes(xlValue).MinimumScale = Range("chtYMinimum")
ws.Protect

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
Proper-Chart-In-Excel.xlsm
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
Naresh PatelTraderAuthor Commented:
Mind Blowing ...Hatt's Off
0
 
Naresh PatelTraderAuthor Commented:
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.Cant See Horizontal AxisSee whole data but chart contractedThank You
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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.
0
 
Naresh PatelTraderAuthor Commented:
Noted

Thanks
0
 
Naresh PatelTraderAuthor Commented:
Madam.Teylyn,

Need your help on this Link.

Please help me on this.

Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now