Home

Excel maps tool not working

%3CLINGO-SUB%20id%3D%22lingo-sub-795532%22%20slang%3D%22en-US%22%3EExcel%20maps%20tool%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-795532%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20do%20make%20a%20graph%20which%20shows%20frequency%20of%20geographical%20locations%20in%20the%20UK%20being%20used%20in%20an%20academic%20paper.%20I%20have%20made%20a%20column%20of%20frequencies%20and%20a%20column%20of%20corresponding%20postal%20codes%20and%20have%20highlighted%20these%20to%20try%20to%20make%20a%20map%20graph.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20the%20graph%20that%20comes%20up%20is%20of%20the%20UK%20but%20is%20all%20grey%2C%20the%20other%20axis%20comes%20up%20as%20frequency%20with%20different%20colour%20gradients%20to%20show%20different%20frequencies%20that%20I%20have%20inputted%20but%20the%20colour%20is%20not%20showing%20up%20on%20the%20all%20grey%20map%20of%20the%20UK.%20Does%20anyone%20know%20why%20it%20is%20doing%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20much%20to%20anyone%20in%20advance%20who%20might%20know%20how%20to%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMolly%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-795532%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
molly_h95
Occasional Visitor

Hi there, 

 

I am trying to do make a graph which shows frequency of geographical locations in the UK being used in an academic paper. I have made a column of frequencies and a column of corresponding postal codes and have highlighted these to try to make a map graph. 

 

However, the graph that comes up is of the UK but is all grey, the other axis comes up as frequency with different colour gradients to show different frequencies that I have inputted but the colour is not showing up on the all grey map of the UK. Does anyone know why it is doing this?

 

Thank you so much to anyone in advance who might know how to help!

 

Molly

Related Conversations
Automatic Selling price calculator
nic140274 in Excel on
0 Replies
Search fuction
Alvaro1990 in Excel on
1 Replies
UNIQUE, FILTER function no more available
Fabien_M in Excel on
5 Replies
Pulling specific data from multiple worksheets into one
AmberDDowney in Excel on
1 Replies
Excel
Svein Tore Kristensen in Excel on
0 Replies
Excel Function Question
Nick_Dirienzo in Excel on
2 Replies