title: Use VBA to get data from chart points in PowerPoint
body: <p>I have a bubble chart in PowerPoint, and going to "Edit Data" doesn't work (an Excel process opens but the spreadsheet does not--I've tried the DLL registering at <a href="http://blogs.technet.com/b/bgp/archive/2011/02/03/when-i-click-edit-data-on-a-2007-native-chart-nothing-happens.aspx" rel="nofollow">this link</a>, but it did not work). So I just want to loop through all the points in the chart with VBA and get the data associated (debug.print is fine). That includes three data values per point: x, y, and size. Unfortunately it appears PowerPoint just views it as one series of data--the y value. I set cht equal to the chart object, and then <code>sercol = cht.SeriesCollection</code>, and sercol.Count returns a value of 1. If I <code>set ser = cht.SeriesCollection(1)</code> and <code>vals = ser.Values</code>, I can loop through all and print the value of the y coordinate, but I can't figure out how to get to the x coordinate and size (<code>cht.SeriesCollection(2)</code> is not valid). Is there a way to get the other two data values associated with the point in the bubble chart?</p>