SOLVED
Home

EXCEL DO NOT SHOW GRAPH MAP CHART

Highlighted
Mark 777
Occasional Contributor

EXCEL DO NOT SHOW GRAPH MAP CHART

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

43 Replies

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

Mark,

 

You need this version

 

1611  Buid 7571.2075

 

Excel 2016 Version - Map Charts.PNG

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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

 

 Office_version.PNGmapcharts.PNG

 

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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

ExcelMapsRibbon.JPG

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

I do see Maps in options.

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

 

Maps.PNGAllCharts.PNG

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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.

 

Maps.JPG

 

ExcelMapsRibbonCustomize.JPG

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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 ...

Solution

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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 ... :-)

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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.

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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

 

 

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

omg thank you jeje

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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?

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

Hi Joshua,

 

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

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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

Build.JPG

 

Maps.JPG

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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.

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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).

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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.

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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.

 

 

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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.

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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. 

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

This worked!! Thank you so much!

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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 :-)

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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...

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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.

 

Maps.JPG

 

ExcelMapsRibbonCustomize.JPG


 

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

Hi,

 

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

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

Yes it doesEXCEL 2016 MAPS.PNG

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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.error message.PNG

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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

 

CAN MAP CHART SHOW MULTIPLE LEGENDS

Dear Sergei,

 

Can map charts on excel 2016 show multiple legends 

Re: CAN MAP CHART SHOW MULTIPLE LEGENDS

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. 

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

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

Re: EXCEL DO NOT SHOW GRAPH MAP CHART

simple map the columns you want to use then goto insert that all you need
Related Conversations
Transfering data from one tab to anoter
Albert Scudder  in  Excel  on
7 Replies
Chart for Percentage Complete
Taryn Mancine  in  Excel  on
5 Replies
Complex INDEX MATCH - Need assistance
Monica Bossert  in  Formulas and Functions  on
30 Replies
Hide columns, still use data in charts
Scott Cox  in  Excel  on
1 Replies
Identifying matches between multiple columns
Jeff Tillinghast  in  Excel  on
2 Replies