| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help to read Pie Chart Series Range
Excel 2003, I have an existing Pie Chart and want to extract the Ranges
(cells) used. My code below returns with a "Type mismatch" error. Sub GetPieChartSeries() Dim mySeries As Series ActiveSheet.ChartObjects(1).Activate Set mySeries = ActiveChart.SeriesCollection(1) Debug.Print mySeries.XValues (errors here) Debug.Print mySeries.Values End Sub Thanks, - Pat |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to set chart series border property with variables read from cellvalues? | Excel Programming | |||
| Read series values range of a chart | Charts and Charting in Excel | |||
| x y scatter chart series ranges reset to x(range) = y(range) | Charts and Charting in Excel | |||
| reture the range of a chart series | Excel Programming | |||
| Excel VBA - Read the series' chart data ranges | Excel Programming | |||
Linear Mode
