Dynamic Charts with "Blank" Cells Containing Formulas

[Aladen333]

Hey everyone, this is my first post!

I've figured out how to create a dynamic chart, where the last values of my data are forced to be blank using an IF formula. The range that I created for which this works has the following formula:

=OFFSET(Sheet1!$C$46,1,0,(COUNTA(Sheet1!$C:$C)-1)-COUNTIF(Sheet1!$C$47:$C$58,""))

I am now in need of using a range where I only want the last 3 values of my data. However, the bottom part of my data is blanked out by the IF formula, so I actually want the last 3 number values. So if I used the regular:

[TABLE="class: collapse"]
<TBODY>[TR="class: trbgeven"]
[TD][/TD]
[TD]=OFFSET(Sheet1!$B$1,COUNTA($B:$B)-3,0,3)

I would only end up getting 3 zeros. I tried the following, but that didn't work:

=OFFSET(Sheet!$B$46,1,0,(COUNTA(Sheet!$B:$B)-3,0,3)-(COUNTIF(Sheet!$B$47:$B$58,"")-3,0,3))

There must something I'm not understanding in the nomenclature following the COUNT functions. Please help!
[/TD]
[/TR]
</TBODY>[/TABLE]