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
Maps Data for Scotland
Chris Nicol in Excel on
19 Replies
Excel "Maps" chart is no longer visible
tmayne in Excel on
1 Replies
Hyperlinks in Bing-Maps or 3D-Maps
Flo diehl in Excel on
1 Replies
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies
changing Date format in a pivot table
ahmad ali in Excel on
12 Replies