EXCEL DO NOT SHOW GRAPH MAP CHART

[Mark 777]

MY EXCEL 2016 DO NOT SHOW ME MAP GRAPH SOMEONE KNOW WHAT IS THE POSSIBLE REASON FOR MY PROBLEM???

[#2]

Mark,

You need this version

1611  Buid 7571.2075

[#3]

We do have this version, but there are no Map Charts to be seen.

 

[#4]

Erik, do you see Maps in Options, Customize the Ribbon?

[#5]

Another reason could be what Maps are not included into Spanish SKU you use (if I'm correct), but that better to ask Microsoft

[#6]

I do see Maps in options.

But when I look in All Charts there are no Maps.

[#7]

By default Maps are not in More Charts, they are on upper level in Insert menu. If you don't see them just add in Customize Ribbon into the place you prefer.

[#8]

Interesting option ... but not available for me ...
I use MS Office 365 ProPlus Version 1609 (Build 7369.2102) .... so I have to wait for an update ...

[#9 · Accepted solution]

It looks like you are on First Release for Deferred Channel. Just in case, you may check here https://technet.microsoft.com/en-us/office/mt465751.aspx which features on each channel are introduced

[#10]

After a reinstall I can not see anymore the build version.

The only thing I can see is that I have Excel 2016 - 16.0.4456.1003 (Office Professional Plus 2016)

So I think I have to wait for that option...

Additional remark ... with the Channels MS is making it complicated ... :-)

[#11]

Guys i can add maps but excel do not recognize this command anyone know why??

[#12]

Hi Mark,

If you see it as disabled in the Ribbon the only my guess this functionality is not activated in Spanish SKU (as i remember you have correct O365 build). Based on discussions in this site non-US SKU:s could differ from US ones, sometimes by design, sometimes by mistake.

In this situation better to open the support ticket, Microsoft has to know for sure.

[#13]

i can test the english version on my tablet and spanish version in my all in one but my pc and my tablet have the same problem they can add to ribbon maps but do not work in the option recommended charts

[#14]

Mark, and what's your plan on Office365 subscription?

[#15]

I have not suscription this problems are in Microsoft Office 2016 pro

[#16]

Yes, Map Charts works with O365 subscription only.

Note: Map charts are only available in Excel 2016 if you have an Office 365 subscription.

https://support.office.com/en-us/article/create-a-map-chart-f2cfed55-d622-42cd-8ec9-ec8a358b593b

[#17]

omg thank you jeje

[#18]

I am having the same issue. This feature has been requested by one of our users. I downloaded the latest version I could from the Current channel (Version 1702 (Build 7870.2020)), but I still do not see the Maps option in the ribbon. (It shows it is there when looking at the customize ribbon) What am I doing wrong?

[#19]

Hi Joshua,

Strange, if you have valid O365 license Map Chart shall be visible for this build. If not you may open support ticket.

[#20]

Thanks for the reply.  We have the Office 365 Enterprise E3 subscription.  I guess I would open a support ticket with O365 support?

[#21]

I guess so, at least i have no idea what could be wrong. I'm on the same build, also E3 and have Maps in Ribbon

[#22]

On a slow insider can you use maps charts free??? Without Subscription?

[#23]

Mark, i have valid O365 E3 license, just my channel is Slow Ring

[#24]

O365 support had me try the steps in this thread https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10/no-map-chart-feature-in-... which is basically what I had done, but not on a clean build. For additional support they pointed me to this https://support.microsoft.com/en-us/help/3186091/support-options-for-microsoft-office-application-is... which basically says to look at forums like this, or pay MS for additional application support. When I get time I will do a clean build and install and see if that corrects my issue. If it does, I will report back here for others.

[#25]

1) Try to check Customize Ribbon as in this conversation above if you see and may add the Maps. I'm suspicious what clean installation helps, but who knows. And you may try to install Office from your subscription on any other PC to see if Maps appears or not. That's not time consuming.

2) It's strange with support. You ask how to install the functionality which you have to have with your license (that shall be free), not how to use it (yes, that costs money).

[#26]

I am making progress and have determined it must be something buried in our customization.  I made time to pull out a brand new machine with factory image and did a direct install from portal.office365.com and the option is there.  Once I track down the issue I will post back incase anyone else runs into the same problem.

[#27]

Hi Joshua, 

Any update by chance?  I am having the same issue using my O365 ProPlus subscription, Deffered Channel, Version 1609 (Build 7369.2127).  I don't see Maps under Charts in the Ribbon, or in the Customize Ribbon settings option.

[#28]

Not much.  After I did the install via the portal download and it worked.  I uninstalled and installed our custom build and the problem was there.  However, I had failed to notice when I did the first install that the factory image had a stub install for Office 365.  When I uninstalled, I uninstalled the stub as well as our custom build and then reinstalled from the portal download and the problem was still present.  I have not had time since then to do any more troubleshooting.

[#29]

I solved it by following this link:

https://support.microsoft.com/en-us/help/3185078/how-to-switch-from-deferred-channel-to-current-chan...

it changes your Office365 subscription to current channel. 

[#30]

This worked!! Thank you so much!

[#31]

Thanks.  I am not sure that fixes it as much as I think Microsoft has fixed the Click to run install package.  My reasoning is this:  I used the config file to download the current channel in the past(setup.exe /download download.xml with the channel set to current) and updated my system and it did not work.  After running the script and having my system update(and the issue being fixed) I downloaded again using the config file and applied the update to 2 other systems and it fixed the issue for them(No need to run the script)

Either way, it is working for my users now :-)

[#32]

Agree! I also had the same issue and needed to change from deferred Channel to current channel
In this link:
https://support.microsoft.com/en-us/help/3185078/how-to-switch-from-deferred-channel-to-current-chan...

[#33]

The map chart shows on my excel ribbon. however when I select the data and click insert and choose maps it does not give me any maps rather it shows bar charts and pie charts. Kindly advise I need the maps for a work presentation.

looking forward to feedback

---

@Sergei Baklan wrote:

By default Maps are not in More Charts, they are on upper level in Insert menu. If you don't see them just add in Customize Ribbon into the place you prefer.

---

[#34]

Hi,

Just to be sure - you click on Globe icon with Maps title?

[#35]

Yes it does

[#36]

hello could you help with a step by step way of doing this. Moreover, if i open an excel file from a friend who use map charts it says im not able to view this with my version of excel. I have attached the error message. Kindly advise.

[#37]

Thanks, my colleagues, I have been absent from this conversation for a long time. It seems that the only explanation of this problem is that the maps only work in office 365 what I do not have clear is that if you have excel of pc you can connect your account of office 365 and thus automatically clear the option of maps

[#38]

its working now. I converted my excel from deferred channel to current channel

[#39]

Hi , I have version 1701 (7766.2096) Will I get Map Chart (not 3D Maps) in this version ?

[#40]

Hi Jeffry,

I guess so, but only if you are an Office 365 subscriber. Map Chart was introduced for subscribers with the build 7571.2072

[#41]

Dear Sergei,

Can map charts on excel 2016 show multiple legends 

[#42]

Hi,

Not sure i catch you - Maps chart could be with value (gradient) legend or category legend. https://support.office.com/en-US/article/create-a-map-chart-f2cfed55-d622-42cd-8ec9-ec8a358b593b. Category legend shows colors for multiple categories. 

[#43]

At this moment I have Excel 2016 - 16.0.4549.1000 (MS Office Professional Plus 2016) and still the option is not yet available .... 

[#44]

simple map the columns you want to use then goto insert that all you need

[#45]

Hi Sergei

Hope you can help me as well... 

I don't even have the map option.... 

and I have above version...  Do you have any idea why it doesn't work?

Thanks

[#46]

Hi Michael,

Unfortunately i see no pictures within your post, better to attach them

[#47]

Sergei, I followed your instructions on making sure my maps are visible in Excel 2016 (just upgraded).  However, I was denied adding Maps to Main Tabs.  Said it needed to be a customized ribbon.  Help!

[#48]

Hi Jeff,

Are you Office 365 subscriber? Map Chart is available only for them.