+ Reply to Thread
Results 1 to 3 of 3

3D maps excel 2016 add data labels

  1. #1
    Registered User
    Join Date
    07-17-2018
    Location
    Essex, UK
    MS-Off Ver
    ver 14.0.7208.5000 (32-bit)
    Posts
    4

    Red face 3D maps excel 2016 add data labels

    Hi guys

    I was just wondering if anyone could help with a small issue with Excel 2016 3D maps

    I have just been upgraded from Excel 2010 to 2016 (still three years behind i know) i have been looking at 3D maps and was thinking about doing some analysis on demographics using post codes. I have got the hang of it to a degree but wondered if there is a way i can add data label (totals) to the top of my bars on the 3D map. The bars obviously display by height how many postcodes there are in that particular area that meet my criteria, some are tall and some short, to make the map a little easier to understand by the end user i think it might be useful to add a data label (in the form of a total number) on the top of each column.

    Does anyone know if this is possible?

    Also is the map exportable in anyway? would it just be a case of 'snipping' it out?

    Many thanks for any help in advance

    Simon

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: 3D maps excel 2016 add data labels

    I don't think there are data labels equivalent to that in a standard chart.

    The bars do have a detailed tool tip but that required the map to be interactive and not a snapped picture.

    You could add annotation to each point. Select a stack and right click to Add annotation.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    07-17-2018
    Location
    Essex, UK
    MS-Off Ver
    ver 14.0.7208.5000 (32-bit)
    Posts
    4

    Re: 3D maps excel 2016 add data labels

    Thanks for your reply Andy.

    I have added a legend to the map and as all the columns are different colours it gives some indication as to the totals for each column.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 02-17-2018, 01:18 PM
  2. Format Data Labels Vertically using Pareto in Excel 2016
    By 1gambit in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-03-2017, 01:39 PM
  3. Replies: 1
    Last Post: 09-18-2017, 08:27 AM
  4. Replies: 0
    Last Post: 09-06-2017, 10:41 AM
  5. Replies: 1
    Last Post: 04-12-2017, 03:25 AM
  6. Custom Globe (3d Maps Excel 2016)
    By Skagyeix in forum Excel General
    Replies: 0
    Last Post: 04-05-2017, 06:04 AM
  7. VBA surrounding embedding Google Maps in Excel not working in excel 2016
    By Dtrix in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-09-2016, 07:04 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1