If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Walk over all the points in a series and extract the X value?
Hi
I am using a standard clustered column chart in Excel 2003. I would like to be able to walk over all the points in a series and extract the X value for inspection. Is this possible? I cannot see how to do this. Thanks in advance, Chrisso |
#2
|
|||
|
|||
Walk over all the points in a series and extract the X value?
On 14 Aug, 09:13, Chrisso wrote:
Hi I am using a standard clustered column chart in Excel 2003. I would like to be able to walk over all the points in a series and extract the X value for inspection. Is this possible? I cannot see how to do this. Thanks in advance, Chrisso I should have stated that I have the code to walk over the points - I just cannot see how to extract the X value for each point: Dim cht As Chart, ser As Series Set cht = ActiveChart Set ser = cht.SeriesCollection(1) Dim pt As Point For Each pt In ser.Points ' ## how do I get the X value for pt? Next pt Cheers Chrisso |
#3
|
|||
|
|||
Walk over all the points in a series and extract the X value?
Use
Dim cht As Chart, ser As Series Set cht = ActiveChart Set ser = cht.SeriesCollection(1) Dim I As Integer For I = 1 To ser.Points.Count Debug.Print I & ": " & ser.XValues(I) Next I On Fri, 14 Aug 2009 08:58:12 -0700 (PDT), Chrisso wrote: On 14 Aug, 09:13, Chrisso wrote: Hi I am using a standard clustered column chart in Excel 2003. I would like to be able to walk over all the points in a series and extract the X value for inspection. Is this possible? I cannot see how to do this. Thanks in advance, Chrisso I should have stated that I have the code to walk over the points - I just cannot see how to extract the X value for each point: Dim cht As Chart, ser As Series Set cht = ActiveChart Set ser = cht.SeriesCollection(1) Dim pt As Point For Each pt In ser.Points ' ## how do I get the X value for pt? Next pt Cheers Chrisso Regards, Tushar Mehta Microsoft MVP Excel 2000-present www.tushar-mehta.com Excel and PowerPoint tutorials and add-ins |
#4
|
|||
|
|||
Walk over all the points in a series and extract the X value?
Thanks Tushar - just what I needed.
Chris On 14 Aug, 18:11, Tushar Mehta ng-underscore-poster-at-tushar-hyphen- mehta.see-oh-em wrote: Use * * Dim cht As Chart, ser As Series * * Set cht = ActiveChart * * Set ser = cht.SeriesCollection(1) * * Dim I As Integer * * For I = 1 To ser.Points.Count * * * * Debug.Print I & ": " & ser.XValues(I) * * * * Next I On Fri, 14 Aug 2009 08:58:12 -0700 (PDT), Chrisso wrote: On 14 Aug, 09:13, Chrisso wrote: Hi I am using a standard clustered column chart in Excel 2003. I would like to be able to walk over all the points in a series and extract the X value for inspection. Is this possible? I cannot see how to do this. Thanks in advance, Chrisso I should have stated that I have the code to walk over the points - I just cannot see how to extract the X value for each point: * *Dim cht As Chart, ser As Series * *Set cht = ActiveChart * *Set ser = cht.SeriesCollection(1) * *Dim pt As Point * *For Each pt In ser.Points * * * *' ## how do I get the X value for pt? * *Next pt Cheers Chrisso Regards, Tushar Mehta Microsoft MVP Excel 2000-presentwww.tushar-mehta.com Excel and PowerPoint tutorials and add-ins- Hide quoted text - - Show quoted text - |
Thread Tools | |
Display Modes | |
|
|