Return value Excel sees as BLANK

**ybu1106** · 08-23-2010, 10:29 AM

I'm trying to graph a chart, with the chart displaying the data as someone else enters it in from another excel sheet, so I'm trying to link the cells in my report to the original data entry cells, so when they are updated, my chart updates with it. I 've using this formula formula for the chart

XValues =OFFSET('Last So Many'!$A$5,COUNTA('Last So Many'!$B:$B)-'Last So Many'!$E$1,0,'Last So Many'!$E$1,1)
YValues=OFFSET('Last So Many'!XValues,0,1)

Where column A contains the Weeks, and Column B contains the data, also E1 contains the # of weeks I want the chart to display counting from the most recent data entered. In the following example, Week 4 is the most recent, and I want to link All column B cells to cells correspond in the Orginial report, so I want all Column B to contain linked formulas. The originial data cell also contains formula, that if it either returns 0 or a value.

Week Fill Rate
A B E1=5
1 93%
2 94%
3 92%
4 91%
5
6
7
8

I've tried for Week 4 Column B:
=IF([OriginalData.xls]FillRates'!$D$8=0, "", [OriginalData.xls]FillRates'!$D$8)
=IF(ISBLANK[OriginalData.xls]FillRates'!$D$8, "", [OriginalData.xls]FillRates'!$D$8)
=IF([OriginalData.xls]FillRates'!$D$8=0, " ", [OriginalData.xls]FillRates'!$D$8)

I want the chart to NOT show Week 5 or any other weeks that contains 0, but I'm having issues with that.

Please help! Thanks!

**Andy Pope** · 08-23-2010, 10:36 AM

Can you post example workbook

**ybu1106** · 08-23-2010, 11:14 AM

Here is the dummy file

**Andy Pope** · 08-23-2010, 11:29 AM

Your example appears to work. Is there suppose to be something wrong with the example you attached?

**ybu1106** · 08-23-2010, 12:13 PM

I didn't put in any forumlas for the reference cells (Column B). As mentioned above, I want them to link to another worksheet/book with orginal data, Here is a revised version of the dummy workbook