Thanks Andy - I have seen that before on another post but I cant really understand it and apply it to my spreadsheet...when I use the exact same formula as you have shown the legend labels still then just show as #NUM!