Using GET.CHART.ITEM on data points in Excel 2003

Have you tried using the object browser to check for members of "Series" in 2003?

No, it has to be that. Reason being, when I have arrow1X and arrow1Y output their value to a cell to check what it is, it just gives me #VALUE!. Then when I run this:

Please Login or Register  to view this content.

It gives me an error at the last line, since there are no numbers to do arithmetic on. And yes, I did have it output "start" and "last" and they are the correct values, so that's not the problem either. Hell, I even changed 2 to 2.0 and 142 to 142.0 to make sure it registers as a Double (they are all Double values).

Originally Posted by gjcase

Have you tried using the object browser to check for members of "Series" in 2003?

How do I do this?

Yeah I even checked just now by explicitly activating it.

To access the Object Browser, from the VBA editor, select View/Object Browser. Select Series from the left window, and you can see all members in the right window. Selecting one of them and the "?" will bring up help on that item.

Well, the whole thing looks like this:

Please Login or Register  to view this content.

So the thing is meant to draw a box, put text in it, then place arrows that touch the box and point to the two data points I want. I already double-checked to make sure the correct values are being passed into the Subroutine from my main Subroutine. I made sure to make my chart active explicitly. No idea what else to try.

I don't see how it would help. I open a .csv file with two columns of data of equal length. It's a plot of power vs. time. That's all there is. "start" is the first row where data starts. I get the length of the column and my "last" variable is the length - "start". This may change sometimes, but I know it's accurate from testing. Regardless, I can input my own values for "start" and "last", well within the data range, and it still won't work.

I'm sorry for being so apprehensive about it, but I'm using data from my work and I don't want to break any rules here. What I did do though is make two columns, 1-40 by increments of 1. Ran my macro on it and it was fine on 2007, same error on 2003.

The relevant parts are this:

Please Login or Register  to view this content.

If I do

Please Login or Register  to view this content.

I get #VALUE! as output instead of a number. So if you want to reproduce this, make an XY scatter chart (I use mine with non-smooth lines) and then just pick two points from the series as "start" and "last".

I don't see how anything else could be the problem if that's the part that screws up. Everything up until that point is working fine, and then it breaks on those lines. =/

Huh. That just makes me curious as to why it works in 2007. I guess they made the code figure that out on its own or something. In any case, IT WORKS! You are my hero. Thanks for being so patient with me. I really appreciate this.