Forum Discussion
Excel maps with NULL data
I'm exploring the idea of using Excel as a dashboard for generating maps. I'd like the map to be of an entire state showing counties, but be able to shade counties with no data to seperate them from...
rzrbaxfan Use the error value #N/A in the data-series cells with no data (type It without quotes). To derive that value in a formula, use the NA function, for example:
=IF( ISBLANK(C2), NA(), C2 )