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 |