Free online mapping services open up a world of possibilities for your creative, practical and professional projects. Nik Rawlinson grabs his passport.
You might not think of mapping as an everyday computing task, but the technology is becoming ubiquitous. Google, Apple and Microsoft each have their own mobile platforms, which draw in geographical data to help us navigate from A to B, geotag our photos and pull in weather reports from the web.
Those basic functions, however, represent only a fraction of the potential on hand. We literally have the world in our pockets – and there are a lot of things we can do with it. The possibilities include creating your own customised maps; navigating and exploring more effectively; and even promoting your business through Street View.
Embed a map in Excel
If you’re putting together a report or presentation that relies on geographical data – such as country populations or vote share in different cities – you can make that data more accessible and visually interesting by plotting it on a map, rather than a boring old graph.
You can do this directly within Excel, but to make it work you have to format your data in precisely the right way. The top row of your data table must contain column headers, to define the data. Below this, the first column must contain only location names, with all other columns being entirely numeric. You can see a sample table above right, showing cities in column A and a statistic of your choice in column B. (We’ve chosen cars, but don’t hold us to the accuracy of the data.)
This story is from the September 2017 edition of PC Pro.
Start your 7-day Magzter GOLD free trial to access thousands of curated premium stories, and 8,500+ magazines and newspapers.
Already a subscriber ? Sign In
This story is from the September 2017 edition of PC Pro.
Start your 7-day Magzter GOLD free trial to access thousands of curated premium stories, and 8,500+ magazines and newspapers.
Already a subscriber? Sign In
Robobutlers may never happen, but robot care workers are on their way
Do you hate loading the dishwasher enough to pay someone to do it remotely? Nicole Kobie wonders about the weird future of home robots
Technical debt
Cutting corners now means more work down the road - but Steve Cassidy asks whether that's always a bad thing
Zyxel ZyWALL ATP500
Zyxel delivers tough gateway security and advanced threat protection at a very appealing price
CREATIVE WORKSTATIONS
Intel and AMD both offer compelling CPU choices for workstations, giving us ten machines with the widest variety of specifications we've seen for years
ANDROID PHONES FROM £219
As this roundup of four affordable contenders shows, there's no need to spend a fortune on a phone
Amazon Echo Pop
If you want a compact Alexa smart speaker, the Pop is now the cheapest choice - but what does it really add?
Getac X600
A powerful alternative to the Panasonic Toughbook 40, with the bonus of optional Nvidia graphics
Amazon Fire Max 11
With its 2K screen and sleek design, this is Amazon's best tablet yet-but FireOS remains a hindrance
Google Pixel Fold
The Pixel Fold delivers with a thin and durable design, a wide front display, smart software and great cameras
Welcome to the Fediverse
Have commercial social networks had their day? Darien Graham-Smith looks at the free, community-run apps that could usurp Twitter, Reddit and the Meta empire