Home Excel

Charts and Visualizing Data

19 Conversations

Latest Activity

Custom List Message Item

Hello,

Need assistance in creating line charts from a huge data set using some tool or formula. New to excel and don't know much about the details in excel where i can create the same for a huge data set.

The data contains 3 columns and 100k rows from which

... Read More
136 Views
7 Replies

Not 100% sure about what you need, but maybe this helps a little...

 

Best, Oliver

Hi everybody!

I'm a new excel and research practician...

I know something about the anova data analysis but I've never done this analysis in excel.

Someone could help understand the dataset to organize, the dialog box, in conclusion...where to put which data

... Read More
43 Views
0 Reply

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?

mapcharts.PNG

Read More
311 Views
7 Replies

Problem is related to installation with the Deployment Tool. If we install with the Deployment Tool there is no Map Chart available. If we install from the Office 365 por

... Read More

I have the same issue. I cannot see the maps option under charts. Where you able to solve it?

Can you simply rotate a chart(X/Y) where the primary and secondary data would be on top and the primary axis is on the left?

65 Views
3 Replies

Excel has a limitation that it doesn't allow you to display more than 255 series or data per chart.

 

To learn more about this, see:

https://goo.gl/EoETOs

https://goo.gl/1ukQmO

Read More

You can simply do that.

 

Change the way that data is plotted

  1. Click anywhere in the chart that contains the data series that you want to plot on different axes.

    This displays

... Read More

I have a very large Excel chart I need to select nonadjacent cells from different columns from to copy and use to create line graphs. Is this even possible?

37 Views
1 Reply

I am trying to make a chart of my business expenses. I have on one side their "type" of expense and on the other side the "cost" of the expense. But when i put the data into a pie chart it keeps making multiple of each type its not collating the same type

... Read More
60 Views
1 Reply
Hi Taegan

You will need to summarize your data (ideally using a pivot table) before you can create a pie chart from the data.

Highlight the data from Type to Price and all ... Read More

 

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
42 Views
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
198 Views
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.

196 Views
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?

Hello,

 

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
100 Views
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
588 Views
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
132 Views
3 Replies

Hello,

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

 

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

 

 

So

... Read More
123 Views
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
83 Views
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:

Clustered_Stacked.PNG

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
92 Views
0 Reply