This is part 3 of a 4-part series on The Making of Manhattan’s Coffee.
Read Part 1 and Part 2.
Excel has a powerful 3D Map feature. I discovered it quite by accident when Navya shared a really interesting screenshot of what could be done with it.
I started with two inputs. First, an Excel file that had each coffee shop’s address, latitude, longitude and population coverage. Second, a shapefile with the coverage area of the Manhattan coffee shops.
By setting the “lat” column as Latitude, “lng” column as Longitude, “Pop” column as height and “store” column as the category, we instantly get a map that can be rotated in 3D.
You can also import a Shapefile to create a Choropleth.
This gives us a choropleth in Excel.
You can combine both of these into a single map by adding them as separate layers using the “Add Layer” button.
Excel 3D Map supports “Tours” — views of data that can be converted into a video. A Tour has multiple scenes. Each scene can show its own data. 3D Map transitions from one scene to another smoothly. You can decide the duration of the transition.
To create a new scene, select New scene > Copy of … and make a copy of your scene. Then modify it as you need. When you click on “Play tour”, 3D Map will smoothly move from one scene to another.
To change the delay, select “Scene Options” and change the Scene duration (how long the scene stays on the screen) or Transition duration (how long it takes to move from the previous scene to this scene.)
I applied these to create a single Excel file that has a 90-second tour. This was the file used in the Manhattan Coffee Kings video.
Are you struggling with lengthy and labour-intensive processes of manual inspection at your manufacturing? You… Read More
Managing smarter inventory is always challenging: too much stock consumes money, while too little results… Read More
The global food industry faces significant losses daily due to the spoilage of perishable goods.… Read More
In today’s fast-paced world of e-commerce and supply chain logistics, warehouses are more than just… Read More
What does it mean to redefine the future of manufacturing with AI? At the heart… Read More
In 2022, Americans spent USD 4.5 trillion on healthcare or USD 13,493 per person, a… Read More
This website uses cookies.
View Comments