Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Returning a series collection end Point value
Hi there,
I would like to be able to return the data label as well as the value from the last point of a series collection on my chart. Now I can use this code to find the end point in my series collection P = ActiveChart.SeriesCollection(1).Points.Count However once I have found the end point I want to return the data value and the DataLable (ie.. Dec 06, Jan 07 Date corisponding to my X-Axis) I have tried this code but it doesn't work P = ActiveChart.SeriesCollection(1).Points.Count X = ActiveChart.SeriesCollection(1).Points(P).Value also have tried this .. P = ActiveChart.SeriesCollection(1).Points.Count X = ActiveChart.SeriesCollection(1).Points(P).Datalabe l.Value neither o these methods have worked I NEED HELP PLEASE ! Dan Thompson |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Returning a series collection end Point value
Dan -
Try these: P = ActiveChart.SeriesCollection(1).Points.Count X = WorksheetFunction.Index(ActiveChart.SeriesCollecti on(1).XValues, P) Y = WorksheetFunction.Index(ActiveChart.SeriesCollecti on(1).Values, P) S = ActiveChart.SeriesCollection(1).Points(P).DataLabe l.Text - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Dan Thompson" wrote in message ... Hi there, I would like to be able to return the data label as well as the value from the last point of a series collection on my chart. Now I can use this code to find the end point in my series collection P = ActiveChart.SeriesCollection(1).Points.Count However once I have found the end point I want to return the data value and the DataLable (ie.. Dec 06, Jan 07 Date corisponding to my X-Axis) I have tried this code but it doesn't work P = ActiveChart.SeriesCollection(1).Points.Count X = ActiveChart.SeriesCollection(1).Points(P).Value also have tried this .. P = ActiveChart.SeriesCollection(1).Points.Count X = ActiveChart.SeriesCollection(1).Points(P).Datalabe l.Value neither o these methods have worked I NEED HELP PLEASE ! Dan Thompson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Returning a series collection end Point value
Thanks for your input. Sorry I didn't see your post untill today Feb 23, 2007
Your code all works except for the last line I get an Error on that one. Any better Ideas or code that will work for what I am trying to do ?? "Jon Peltier" wrote: Dan - Try these: P = ActiveChart.SeriesCollection(1).Points.Count X = WorksheetFunction.Index(ActiveChart.SeriesCollecti on(1).XValues, P) Y = WorksheetFunction.Index(ActiveChart.SeriesCollecti on(1).Values, P) S = ActiveChart.SeriesCollection(1).Points(P).DataLabe l.Text - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Dan Thompson" wrote in message ... Hi there, I would like to be able to return the data label as well as the value from the last point of a series collection on my chart. Now I can use this code to find the end point in my series collection P = ActiveChart.SeriesCollection(1).Points.Count However once I have found the end point I want to return the data value and the DataLable (ie.. Dec 06, Jan 07 Date corisponding to my X-Axis) I have tried this code but it doesn't work P = ActiveChart.SeriesCollection(1).Points.Count X = ActiveChart.SeriesCollection(1).Points(P).Value also have tried this .. P = ActiveChart.SeriesCollection(1).Points.Count X = ActiveChart.SeriesCollection(1).Points(P).Datalabe l.Value neither o these methods have worked I NEED HELP PLEASE ! Dan Thompson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Series Collection Name Problem | Excel Programming | |||
How to store the lengthy value in Series collection? | Charts and Charting in Excel | |||
Problems returning Collection object | Excel Programming | |||
Changing source for series collection in charts | Excel Programming | |||
Series Collection Points | Excel Programming |