Hi,
Just wondering if it is possible to create a scatter plot that will omit blank cells. In my example, my x values would be G2:G52, and my y values would be H2:H52. The blank cells actually contain code because data will be drawn into these cells on a daily basis. This is interfereing with the scatter plot and I'm not sure how to avoid it. Thanks!
-Dan
change your formula
=IF(ROW(B1)>COUNT($B$2:$B$52),NA(),INDEX($A$2:$C$52,MATCH(SMALL($D$2:$D$52,ROW(B1)),$D$2:$D$52,0),COLUMN(B1)))
This will work if you are only plotting markers.
If plotting line you will need to use a named range formula approach.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks