| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determining Chart Series Number using VBA
I'm wondering if anyone knows how to use VBA to determine
the index number of an activated data series in a chart. For example, a user clicks on a data series and, when the VBA code is run, the code knows which series in the seriescollection has been clicked on. All help is greatly appreciated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Determining Chart Series Number using VBA
Get Information About a Plotted Point:
http://www.geocities.com/jonpeltier/...html#PointInfo - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ SoCalExcel wrote: I'm wondering if anyone knows how to use VBA to determine the index number of an activated data series in a chart. For example, a user clicks on a data series and, when the VBA code is run, the code knows which series in the seriescollection has been clicked on. All help is greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Chart - determining the color of a chart style | Charts and Charting in Excel | |||
| User Selectable Series and Number of Series for Line Chart | Charts and Charting in Excel | |||
| how can I use a number series with gaps in as a chart axis | Charts and Charting in Excel | |||
| How do I alter the number of bar series in a combination chart? | Charts and Charting in Excel | |||
| Determining Row Number | Excel Programming | |||
Hybrid Mode
