How to Change Data Source of Excel 3D Maps (2 Easy Ways)

The article will show you how Excel 3D Maps change their data source. Excel has its own feature to demonstrate 3D Map on different data. If you are a geographical statistician, this feature may be helpful for you. You can represent an overall information about your country or states with the help of 3D Map feature.


Download Practice Workbook


2 Ways to Change Data Source of Excel 3D Maps

In the dataset, I’ve shown you some information about different States of the USA from today’s perspective.

excel 3d maps change data source


1. Applying Refresh Command to Change Data Source of Excel 3D Maps

In this section, I’ll show you how to use Refresh Command to change data sources. Let’s go through the process below.

Steps:

  • First, convert the States into Geography.

=TODAY()

excel 3d maps change data source

  • Next, using the marked icon, select the data to insert them.

Your dataset now looks like the following picture.

excel 3d maps change data source

  • Thereafter, convert this data into a table.
  • Select the range B4:F10.
  • After that, go to Insert >> Table.
  • Make sure you select My table has headers.
  • Later, click OK.

Now your data is converted to a table. The advantage is, if you enter a new State, it will automatically update the other information.

  • Select any cell of your table.
  • After that, go to Insert >> 3D Map >> Open 3D Map

excel 3d maps change data source

  • Next, the Launch 3D Maps window will appear.
  • Later, select New Tour.

  • After that, the 3D Map window will show up. Rename the Layer if you want. I named this layer Refresh Command.
  • We are working on Table4, so we will be using the data of this table.

excel 3d maps change data source

  • Drag the Date to the Time Field.

  • After that, drag other necessary headers to other fields in the same way.

excel 3d maps change data source

  • You can see the Category data in the legend which is Person per House.
  • The legend will trouble you to view the map, so remove it.

  • Finally, you will see the data according to the States in your 3D Map.

excel 3d maps change data source

  • To change the data source with time, select the Home Tab of the 3D Map window >> Refresh.

This will update the data of your 3D Map. You may not see any changes in a short period.

Thus, you can change the data source of a 3D Map in Excel.


2. Using Custom 3D Maps to Change Data Source in Excel

Another way to change the data source of your geographical statistics is to use a custom image. This image will work as a custom 3D Map. Let’s discuss the process below.

Steps:

  • Convert your data into a table and launch 3D Map tour like the Section 1.
  • In the Home Tab of the 3D Map window, from New Scene >> select New Custom Map.

excel 3d maps change data source

  • After that, name your Custom Map and browse for the image you want to upload as your map.

  • Thereafter, select Auto Fit and click on Apply and Done one by one.

excel 3d maps change data source

  • Next, select Field List. We are working on Table 46 now, so we choose this.

  • Add the necessary headers in the Fields of your Map Layer like we did in Section 1.

excel 3d maps change data source

  • After that, you will see the added data in fields appear on the Custom Map.

  • Click on the Refresh command like in Section 1.

This will update the data of your 3D Map. You may not see any changes in a short period.

Thus, you can change the data source of a 3D Map in Excel.


Practice Section

Here, I’m giving you the dataset of this article so that you can practice these methods on your own.

excel 3d maps change data source


Conclusion

In the end, we can conclude the fact that you will achieve the basic knowledge of how do your Excel 3D Maps change their Data Source after reading this article. If you have any better methods or questions or feedback regarding this article, please share them in the comment box. This will help me enrich my upcoming articles. For more queries, kindly visit our website ExcelDemy.com

Nahian

Nahian

Hello, Nahian here! I do enjoy my efforts to help you understand some little basics on Microsoft Excel I've completed my graduation in Electrical & Electronic Engineering from BUET and I want to be a successful engineer in my life through intellect and hard-work, and that is the goal of my career.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo