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
How to get to the last line with data in an Excel workbook?
seanp413 in Excel on
2 Replies
Excel Formula Question
BigErn1175 in Excel on
3 Replies
Resizing table Error
birkettsl in Excel on
1 Replies
Conditional formatting assistance please
c_frndz in Excel on
4 Replies
delete one marging
fred83 in Excel on
4 Replies