Chart Context Menu Help

Hello All,

I have been moved over to Excel 2010 at work and I noticed that I am missing a very important piece of the Chart Context Menu called "Show Data Sheet". We have chart libraries that it is very helpful to simply right click into the context menu and show the data sheet when we want to dig into the data...now with Excel 2010 we can't. It is hidden somewhere else? I have a hard time believing that Microsoft deleted such a feature...

Here is what I saw with 2003:
2003 Context Menu.gif

Now with 2010:
2010 Context Menu.gif

Thoughts or suggestions?

Many thanks!
Matt

Hello Joseph,

Sorry, you are right, I was lead to believe this was "standard". I just went and talked to the file Owners and they showed me the code they used to create this command. Then they tell me that it isn't possible in 2010 to edit the context menus like it was in 2003. Is this true?

Here is the code they used in the sheet:

Public Function getDataSheet(seco As Series) As String
    Dim intStopWerte As Integer         ' Variable für 1. Komma von rechts
    Dim intStartWerte As Integer        ' Variable für 2. Komma von rechts
    Dim strWerte As String              ' Variable für Größen(Y)-Werte
    Dim dataSheet As String
    With seco
'       Position des ersten Kommas von rechts
        intStopWerte = InStrRev(.Formula, ",") + 1
'       Position des zweiten Kommas von hinten
        intStartWerte = InStrRev(.Formula, ",", intStopWerte - 2) + 1
'       Adressbereich für Größen(Y)-Werte
        strWerte = Mid(.Formula, intStartWerte, intStopWerte - intStartWerte - 1)
        dataSheet = Mid(strWerte, 1, InStr(strWerte, "!") - 1)
        If Left(dataSheet, 1) = "'" Then
            dataSheet = Mid(dataSheet, 2, Len(dataSheet) - 2)
        End If
        getDataSheet = dataSheet
    End With
End Function

Sorry, some of it is in German.

Can this be done in 2010??

Thanks,
Matt

Thanks for the hint! I will run it past the owners of the file.

Cheers,
Matt

Hi Again Joseph,

I showed the owner of the file and he actually said he was aware of this approach....but he said it only works with the cell context menu, not the chart context menu....any sources that show how to do this on the chart context menu for Excel 2010??

Cheers,
Matt

Hi Joseph,

Thanks for your continued follow-up. I really appreciate it. I did as you suggested, but I don't see anything different or a pop up....

rightclickchartarea.gif

Perhaps there is some standard setting in our set up that is not allowing it??

Cheers,
Matt

You are absolutely right, my bad.....though I still don't see anything different:

rightclickchartarea.gif

Brilliant! I am going to send it to the developer and see what he says now!

Thanks for your help Joseph and patience!

I will let you know.

Cheers,
Matt