Get Dyndamic Charts to Ignore Formula

[jtrugger]

I'm running a chiropractic office. In order to see where I've been and where I'm going I keep track of things like new patient visits, patient report visits, cash in, insurance in, etc. I keep track of this on a daily basis on one worksheet. The weekly totals are paste-linked into another sheet. It is this sheet that I would like to use to create a dynamic chart however, in using the OFFSET function to create the chart, the formula counts the 'blank' cells b/c of the paste-link from the previous worksheet. How could I get around this?

 

[jtrugger]

Also, for some reason, the offset ignored the paste link in one column but not the one next to it. In A2 is a date that fills in (down the column) as a weeks information is entered.

---

In A2 are dates that fills in as information is entered. The offset formula for the date is: =OFFSET('Weekly Totals'!$A$2,,,COUNT('Weekly Totals'!$A$2:$A$23)) and it stops at the last date that is entered and expands as planned as new dates populate the next cell below.

---

The offset formula for the adjacent column is: =OFFSET('Weekly Totals'!$B$2,,,COUNT('Weekly Totals'!$B$2:$B$23)) however when checked, this formula selects the entire column (to B23) even when they are 'blank.'