| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Name of a chart series Point
How do I get the name of a chart series Point?
I can not figure the property... For p = 1 To PointsCount pn = ActiveChart.SeriesCollection(s).Points(p).Label TIA |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Name of a chart series Point
IN other words what property do I ask for to determine the label/name? I want
to omit markers for any data point of year 2006. so If right(Point_Name,2)="06" then no lines or markers. " "Candyman" wrote: How do I get the name of a chart series Point? I can not figure the property... For p = 1 To PointsCount pn = ActiveChart.SeriesCollection(s).Points(p).Label TIA |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Name of a chart series Point
Do you mean the data label?
pn = ActiveChart.SeriesCollection(s).Points(p).DataLabe l.Text - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Candyman" wrote in message ... IN other words what property do I ask for to determine the label/name? I want to omit markers for any data point of year 2006. so If right(Point_Name,2)="06" then no lines or markers. " "Candyman" wrote: How do I get the name of a chart series Point? I can not figure the property... For p = 1 To PointsCount pn = ActiveChart.SeriesCollection(s).Points(p).Label TIA |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Name of a chart series Point
Very close!
I actually saw the response to Thompson as well. I added : ActiveChart.SeriesCollection(s).Points(p).HasDataL abel = True pn = ActiveChart.SeriesCollection(s).Points(p).DataLabe l.Text (That got me the data label) z = WorksheetFunction.Index(ActiveChart.SeriesCollecti on(s).XValues, p) (This got me the data point title, PERFECT!) y = WorksheetFunction.Index(ActiveChart.SeriesCollecti on(s).Values, p) THANKS! "Jon Peltier" wrote: Do you mean the data label? pn = ActiveChart.SeriesCollection(s).Points(p).DataLabe l.Text - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Candyman" wrote in message ... IN other words what property do I ask for to determine the label/name? I want to omit markers for any data point of year 2006. so If right(Point_Name,2)="06" then no lines or markers. " "Candyman" wrote: How do I get the name of a chart series Point? I can not figure the property... For p = 1 To PointsCount pn = ActiveChart.SeriesCollection(s).Points(p).Label TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show series name on the chart - but not at every data point | Charts and Charting in Excel | |||
| How do I alter the value of a data point in a chart series | Charts and Charting in Excel | |||
| regarding allocation of chart series point colors | Charts and Charting in Excel | |||
| Series point on a chart | Excel Discussion (Misc queries) | |||
| Is there a property to get the values for a point in a chart series? | Excel Programming | |||
Linear Mode
