Create chart with 2 series of different types

Hi everyone,
I've been working on a macro that manipulates some data, and have been having trouble with one part of it. Specifically, I have three columns of data - one with percentages, one with simple integers, and one with names. I want to write a macro that:

1. creates a new sheet (i think i can do this)
2. creates a new graph that contains 2 series. The data for these series comes from a different sheet (not the activesheet, since that will only contain the graph)

A. A bar graph with the names (column D) on the x-axis and numbers (column C) on the y-axis

B. A line graph with the same names (column D) on the x-axis, and the percentages (column A) on a secondary y-axis, with the range from 0 to 1.

When I do this manually, the wizard tells me that the chart data range is

Please Login or Register  to view this content.

I already have a variable that tracks the last row of data, so the "73" in the range above would be my lastrow variable.

Can someone please help me with this? I've spent 4 or 5 hours trying to figure it out by Googling and trying to record the macro, with no success.

That gets me this:
Screen shot 2011-05-04 at 10.44.14 AM.jpg

How can I go about making the authors series a bar graph while keeping the cumulative one a line graph? And how would I change the x-axis to reflect author's names in both cases?

Whoops, did it on the wrong document. This works perfectly -- I can't thank you enough!!!

One last question: do you know if there's a way to add a single vertical line where the cumulative % = 50%? That is, draw a vertical line at the point where (1) the major gridline that comes from where the secondary axis reads .5 hits (2) the cumulative % curve?