Home Excel

Charts and Visualizing Data

14 Conversations

Latest Activity

Custom List Message Item


I created a chart with a y-axis that consists of text labels (none >15 words).  When I click to format the axis, I am not provided with any align options (e.g., align top, align center, align bottom).  Currently, the text that occupies only one line, dis

... Read More
0 Reply

I'm having problems getting a particular region to display properly in Map Charts. I'm not sure if it's region-specific or a problem with the programme. I'm pulling together a map of Georgia, the country, and a single region, Adjara, is not rendering prop

... Read More
8 Replies

I have a similar problem.
I'm trying to create a map of Italy to second-order administrative division.
I added columns (first and second administrative division), I've chan

... Read More

I don't know an answer, but it looks like Maps overlaps Guria and Ajaria (by the way, it recognizes that name, as well as Adzharia). If remove ratios here you may see kin

... Read More

Hi all,


Windows  10 fr, Excel 2016 fr.


Any location is "not found", whether it's towns, countries, postal codes etc. Has anyone the same problem ?


Thanks in advance.

11 Replies
For testing purposes, i'm using the same data shown in the example : https://1drv.ms/i/s!AqRP0RQrhNWWyAmsAuMHDG80dP99 I connect to Bing Maps using the Insert, Bing Maps i... Read More
For testing purposes, i'm using the same data shown in the example : https://1drv.ms/i/s!AqRP0RQrhNWWyAmsAuMHDG80dP99 I connect to Bing Maps using the Insert, Bing Maps i... Read More

Can you post how you identify locations? Also, how do you connect your Excel data to Bing maps?


Do you get any errors?



I'm trying to use 3D Maps in Excel 2016 with a Microsoft-supplied sample file (Chicago Narcotics Sample File). When I click Insert -> 3D Map, I get the option to insert Tours, as expected. However, when I click on a tour and the separate 3D Map win

... Read More
0 Reply

Great new artical about Maps


You can use a Map Chart to compare values and show categories across geographical regions. Use it when you have geographical regions in your data, like countries/regions, states, counties or postal codes.


Watch Doug from O

... Read More
0 Reply

I am a complete newbie and I have been looking up resources to help me create a simple line graph. I have tried Excel exposure, various videos, and yet those didn't help with the problem I am having.


Everytime I highlight the two columns, it puts both of

... Read More
3 Replies


a Scatter Chart (XY-Chart) can display your values on the X and Y-Axes. I attached a sample file with two sample scatter charts (variations) in it. This article Present your data in a scatter chart or a line chart

... Read More

We are on the current Channel, Version 1611 and Build 7571.2075. I don't see the option to insert a Map Chart. 
What could be the reason that this option is not available?


Read More
0 Reply


Average Cost WA.PNG


So I just installed the latest update to Excel 2016 and now have access to Map Charts.


This is not the same as 3D maps (Which are very cool, see video below then show this to the next person who tells you that Google sheets is as good as Excel...!)




... Read More
0 Reply

I tried 3D maps.

Interesting, i can create basic maps starting from my data. Beside this, it is almost impossible to have the complete control of graphic and visualization. Too basic commands and tools to manipulate data/color/ranges do not allow me a refi

... Read More
1 Reply

Hi Stefano


You can still do some pretty impressive presentations.


Power BI Companies of the World using 3D Maps

Read More

Is there someone who could help me make nice clustered stacked bar charts such the one below:


I would be willing to have the stacked bars side by side as in the chart above. In addition to this, I would be willing to control the gap width between the clust

... Read More
0 Reply

Useful, thanks for sharing

What can I say ? It is just amazing !!! So Thanks for sharing

Excel spreadsheets are all about numbers. But tons of numbers are often not the most effective way to communicate

That’s where charts come in handy. Charts can display numeric data in a graphical format, making it easy to understand large quantities of d

... Read More
6 Replies
Your post got cut off. Or by design does it only show the first couple lines? That's annoying.
thanks for the link to the chart-blog. But some pages can't be find (Points 2, 7, 8).
Maybe someone should update the page.
Greetings from Germany
Andreas (YouTube.com/at... Read More

My favorite way to create perfect charts in one keystroke:

1. Create a chart with Alt+F1 and you get a clustered column chart. 

2. Customize that chart to match your preferred chart style.

3. Right-click the chart and Save as Template. Give the template a na

... Read More
0 Reply