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 
=datasheet!$B$2:$C$73,datasheet!$E$2:$E$73
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.