Hi All, trying and failing on a project here!
Trying to generate a heat map chart in excel broken by postcode area (AB, AL, BB, BS, BL etc.)
I've managed to get it working on a county level (Derbyshire, Kent etc) but cannot fathom how to break it down by postcode. Tried a few online templates and had no joy
See attached what I've managed so far, can someone give me a few pointers on how to go down another level and create this for postcodes?
Many thanks,
Andrew
There are no postcodes in the attached workbook, and no attempt on your part, as far as I can see, to include them. Not a lot we can do, really.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
By the way, if this has been cross-posted, then you had better declare that now before you get found out again.
Hi AliGW
I deleted the tabs which I could not get to work as the file was 10mb+, and I'm struggling to get it down below 1mb. Uploading as an xlsb isn't working for some reason, and neither is uploading as a zip
The previously attached is the best I've got it to work, down to county level. I've taken a screenshot of the best I've done with postcodes (which is very much a step backwards)
Capture.PNG
I don't know if the issue is the column names and order, but I've tried every permutation I can think of. I don't even know if this works down to postcode level
And this hasn't been cross-posted
I have no idea - sorry - and without any data to work with ...
We don't need it all - just provide two counties (Derbyshire & Kent).
Hi AliGW
See attached, I've managed to make the files a bit smaller.
Essentially, Kent has three postcode areas (TN, ME and CT). I'm trying to get the heatmap to show ME with a greater density than TN and CT. But naming ME (Maidstone) doesn't give me any results
Neither of the workbooks includes any postcodes, so I can't do anything to help - sorry.
... and I can't see any graphics at all....
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
I think the OP may have Office 365, as I do. May be something that's not available in Excel 2016.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks