Formulas in C-column causing chart show empty cells as a gap. How to fix it?
The attached file has a properly displayed chart.
Thanks,
hmgrts
Formulas in C-column causing chart show empty cells as a gap. How to fix it?
The attached file has a properly displayed chart.
Thanks,
hmgrts
Last edited by hmgrts; 06-30-2009 at 02:58 PM.
If you change your COUNTA to COUNT it will only see numbers (not formula's).
Also, your yVal needs to move up one...
xVal=OFFSET(Sheet1!$A$2,0,0,COUNT(Sheet1!$A:$A),1)
yVal=OFFSET(Sheet1!$C$2,0,0,COUNT(Sheet1!$B:$B),1)
Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks