In the workbook, try formatting the field 'Rate' so that it hides Null values. You can do that by:
1. right-clicking on one of the points in the worksheet.
2. selecting 'Format'
3. on the left-hand side, click on the Fields button and select 'ATTR(Rate)'
4. Click on the 'Pane' tab
5. At the bottom where it says 'Special Values e.g. Null', click on the drop-down menu and choose 'hide.'
I've attached picture so you can see what to do as well.
2012-01-20_1347.png 24.9 KB
Thank you so much, it worked!