Skip to main content

Data Mapping New Haven

Submitted by Robert Narracci on

Hi Guys, As a favor to the New Haven Independent I've been working on a an Excel file that can express voter data as a heat map (ward by ward). I've been able to push a ward map PDF through illustrator, clean it up, bring it into Excel and explode it into shapes, but can't figure out how to transfer color fills from data cells into the shapes with VBA. I would like the data set cells to be expressed with heat map color ranges using conditional formatting, and then to read the conditional formats and push them into the shapes. Is anyone out there really good at VBA?[[{"type":"media","view_mode":"media_large","fid":"432","attributes":{"alt":"","class":"media-image","height":"480","width":"402"}}]][[{"type":"media","view_mode":"media_large","fid":"433","attributes":{"alt":"","class":"media-image","height":"480","width":"400"}}]]