3D maps - many distinct data points with same location data

D

dhannaa

New Member
Joined
Mar 15, 2017
Messages
2
This seems as an easy task, but unfortunately I can't figure out an easy fix.

I have a data set with rows representing different answers to our poll. Some of the rows contain the same postal code.

Now I am trying to draw 3D map from the data set and Excel understandably combines all the points with same postal code in to one. Nevertheless I don't want this - I want all the answers to be their own data points, not no sum up if they have same postal code.

What would be the best way to solve this problem?
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
You must log in or register to reply here.

Similar threads

J
  • Solved
Sorting occurrences of Postal Code in column / Sorting by occurrence high to low
Replies
7
Views
371
Fluff
Fluff
M
  • Solved
Dynamically Plot Data Points in Scatterplot
Replies
5
Views
480
felixstraube
F
J
  • Question Question
Excel, plot address points on embedded map
Replies
1
Views
667
Rogojosh
R
N
  • Solved
Excel 2016 VBA - Pull data from multiple sheets to One with specificities
Replies
3
Views
250
mumps
mumps
M
  • Question Question
Conditional Formatting/Moving Rows Based on Matching and Opposite Data
Replies
1
Views
204
Madam_Xavier
M

Forum statistics

Threads
1,223,228
Messages
6,170,874
Members
452,363
Latest member
merico17

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top