Chart Pop Ups

[acjc7602]

I have seen this trick before but am unsure how to do it. I have data in a table in a worksheet and have a chart created in the same worksheet. I would like to be able to click on a cell (or some point) in that worksheet and have the chart pop up over top of the data in the same worksheet. Then I would like to minimize the chart when I am done to view the data again. I know that I can hyperlink the data to the chart in if it is in another worksheet but I really want to be able to have the chart pop up and minimize over the data that I am viewing. Can someone tell me how to do that? Thanks.

 

[tusharm]

I don't quite understand what you want to do but if you can do whatever it is with the chart in another worksheet, you can do the same with "this" worksheet. Just think of "this" worksheet as "another" worksheet and do whatever it is you did with the chart in the other worksheet.

 

[MikeFallows]

How about just charting the data, sizing the chart directly over the data and then placing a toggle button above or to the side of the data that hides/shows the worksheet.

Private Sub ToggleButton1_Click()
    If ToggleButton1.Value = True Then
        ActiveSheet.ChartObjects("Chart 1").Visible = True
    Else
        ActiveSheet.ChartObjects("Chart 1").Visible = False
    End If
End Sub

I'm not sure exactly what you want visually but this should work and maybe you can adapt it to suit your needs.