J
Jeremy Hendrix
So there's no way to access the datasheet associated with the chart?
There was some sample code on the MS site (http://support.microsoft.com/kb/267974)
that looked promising, but it was for office 2000 and doen't work with 2007. It checked
If oPPTShape.Type = msoEmbeddedOLEObject Then
If oPPTShape.OLEFormat.ProgID = "MSGraph.Chart.8" Then
Set oGraph = oPPTShape.OLEFormat.Object
You could then access
oGraph.Application.DataSheet
But now that that shape is of type msoChart, it seems you can't do anything with it. Is this your understanding?
This is very frustrating as I have some charts (line graphs) with lots of data series. In the past I used checkbox controls to turn the display of these series on and off so you could "de-clutter" the chart. I would do this by having a macro modify the datasheet when the box was checked/un-checked. If I can't get to the datasheet anymore, I don't know of another way to do this....
There was some sample code on the MS site (http://support.microsoft.com/kb/267974)
that looked promising, but it was for office 2000 and doen't work with 2007. It checked
If oPPTShape.Type = msoEmbeddedOLEObject Then
If oPPTShape.OLEFormat.ProgID = "MSGraph.Chart.8" Then
Set oGraph = oPPTShape.OLEFormat.Object
You could then access
oGraph.Application.DataSheet
But now that that shape is of type msoChart, it seems you can't do anything with it. Is this your understanding?
This is very frustrating as I have some charts (line graphs) with lots of data series. In the past I used checkbox controls to turn the display of these series on and off so you could "de-clutter" the chart. I would do this by having a macro modify the datasheet when the box was checked/un-checked. If I can't get to the datasheet anymore, I don't know of another way to do this....