Home

Charts and Visualizing Data

45 Conversations

Latest Activity

Custom List Message Item

Hello,

 

I would like to create a map in Excel. I have Excel 2016, and according to the tutorial video online, I should be able to create a map of the US that shows differenct values for different areas. The button should be under "Insert" and in the Charts

... Read More
105 Views
5 Replies
Hi,
Could you please confirm that excel 2016 (I AM NOT TALKING ABOUT OFFICE 365) does NOT come with map charts, it ONLY comes with 3D maps ???

AND if that is the case, coul... Read More

Hi Klara,

 

Maps chart is available for Office 365 subscribers only, is that your case?

Hi all, I have 10 groups that each one has 4 levels. Just wondering how show each level of the groups with different color, e.g., first level in all groups be recognized with yellow, second one with green…

 

 

45 Views
0 Reply

I hope someone can help or guide me in the right direction!

Let's say I have two values in Sheet1 (True & False) and these values can increase or decrease.

How can I set up a dynamic chart or may be a line graph (Corresponding to Value True and False) on a

... Read More
59 Views
0 Reply

Hi, I have a problem with my heatmap. I would like to add ann option to a dashboard that would show me for example just clients with 4 or more red/green fields. I work on excel 2010. 

Example of how my heatmap look is attached. 

33 Views
1 Reply

Hi Bartosz,

You have some conditions for your red/green rules. Add one more heleper column to your range and COUNTIF in it from B to I where such condition(s) match. After

... Read More

Can anyone help me with conditional formatting on a different level in a pivot table?

 I have 3 levels - Product category > Sub Category > Product. I want to apply conditional formatting to only relative to the products cells. In Windows, I have seen that

... Read More
41 Views
0 Reply

I would like to print my excel charts to my Canon Por-100 with the highewst possible resolution. How can I increase the resolution of my Excel charts. Microsoft gives instructions entitled: "How to change the export resolution of a PowerPoint slide". My q

... Read More
42 Views
1 Reply

Hello,

Excel does not have a setting to change the chart resolution. AFAIK, the printer driver will determine how the chart is printed. This has nothing to do with export

... Read More

I can see the 3-D map &  can use the the Flat to 2-D, but I don't see the Map Chart in Office 365  ProPlus.mapchart.png

 

How can I add it in?

Read More
43 Views
0 Reply

Hi all,

 

I have a rather huge excel (about 40M file size) with a lot of rather complex calculations (over 500.000).

Might be this is the reason ... but I can't insert a picture or a chart anymore. The respective icons are grey, copy&paste a picture leads to

... Read More
123 Views
5 Replies

Greyed out icons usually refer to some kind of protection (workbook or worksheet).

Or it is a shared workbook where some features are not possible or allowed.

 

Read More

How do I organize my list alphabetically  on XL spreadsheet so it starts with A and ends with Z names

44 Views
1 Reply

Hi Nora,

 

Depends on what do you mean under the list, Data->Sort in Ribbon menu could work

Greetings.  Excel must calculate the data it uses to plot a smoothed line in a scatter plot.  How can I access this data?

43 Views
2 Replies

Hi Sam,

 

For my knowledge if only you write some subroutine which repeats smoothing algorithm and calculate intermediate points yourself. See for example

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/how-does-excel-plot-smooth-curves/c751e8ff-9f99-4ac7-a74a-fba41ac80300

Read More

For some reason, I can not print gridlines (vertical/horizonatal) on my sheets, as needed. I have selected gridlines to print and view And I have tried setting the print area for such....and no luck achieving the gridlines.

 

Is there another suggestion tha

... Read More
56 Views
1 Reply

How do can get totorials that can make manupolate excel well?

28 Views
0 Reply

I will attach three images. The first is this combo chart, but as you can see, the months are in reverse chronological order. 

 

2017-07-28 15_39_41-Book1 - Microsoft Excel.png

 

However, attempting to flip all data by selecting the "Categories in reverse order" button in the formatting of the x-axis only

... Read More
74 Views
1 Reply

Hi Robin,

 

On your initial graph after you added secondary vertical axis add secondary horizontal axis, it will repeat the primary one and will be on the top of the graph.

... Read More
Best Response

I accidentally unchecked the "remove data from external data range before saving the workbook" and I will like to enable it again.  Any lead is greatly appreciated.

 

Thanks,

Brenda

56 Views
0 Reply

I'm working with numerous charts that are formatted with part column (# data) and part line (% data).  Each month, new data is entered into the source spreadsheet.  When selecting the appropriate data to update the charts, if not in consecutive cells, the

... Read More
86 Views
3 Replies

Hello,

 

what do you mean with "if not in consecutive cells"? Do you want to plot from a start month, then leave a gap?

When you select the chart, the data is highlighted. Y

... Read More
Best Response

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
683 Views
11 Replies

I was having similar problems with several maps, and after some trial and error, I solved my problem for Turkey by opening bing maps, and looking for the region names on

... Read More

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

I have a chart with past and forecasted figures for several series of data.

I set the colors of each serie in order to have something nice and meaningful : 1 color per serie, dotted for forecast.

Each time I filter my data to see a particular serie, Excel d

... Read More
95 Views
2 Replies

Hello,

 

if this is a pivot chart, take a look at Jon Peltier's article Pivot Chart Formatting Changes When Filtered It has a few suggestions and workarounds. 

Read More

Hi,

 

What is the data source for your charts? Are they power charts, or they are built on tables/ranges?

Ciao,

 

I have an easy question, I hope you can help me.

 

I have a table with in column A a list of project codes(code ex is E-APT00200_15). I want to filter column A for a group of project codes. I could do it one by one, selecting everytime the button "add

... Read More
148 Views
5 Replies

Hi Michele,

 

Not sure i understand everything, but

1) Let assume you have a table with codes like this

 

Table1.JPG

and you filtered it somehow, let say only Code1 and Code3 are selecte

... Read More

Hi,

 

I have several charts in a Excel file, some charts not showing Axis-X not showing actual Label, instead showing 1,2,3...

 

Because I have macro to hide then unhide Rows to show to unshow certain charts.

Whatever charts until hide status, will not display

... Read More
122 Views
0 Reply

India map chart.png

 

All states except Telangana are mapped, please check.

 

India map chart.png

Read More
110 Views
0 Reply

Dear all,

 

I have bunch of data, and I need to simply draw a graph. As you see in the example, I need the horizental axis to bee the month column, but excel assigns numbers authomatically I guess! Also if I want to change the month order from last to first

... Read More
128 Views
4 Replies

Hello Sara,

 

how Excel determines which and how columns are charted when inserting a chart is dependant on how you have selected the data. If the result does not suit (wha

... Read More

I am currently taking an advanced Excel class in hopes of getting expert certification in June. In that class, we are given pre-determined spreadsheets and data sources. One of the things I am currently working on is Power Sheets... which are AWESOME....

... Read More
109 Views
0 Reply

I need someone to help me to do this activity please create a macro in Excel that allows to evaluate the area of the square, Circle, Triangle and two that investigate in a Free way, all must be elaborated in a single macro in a worksheet in Excel. By fa s

... Read More
100 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
1,209 Views
11 Replies

Finally we got the Map Chart with Version 1704 (Build 8067.2115)

 

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?

Hello! I have two big worksheets, with data from several ID's and their info (each line refers to one subject, the first column is the subject's ID and the next ones, his info. Each sheet has different info about the subjects). I need to merge them into o

... Read More
119 Views
2 Replies

Hi Khalil,

 

Power Query would be best for this. I would apply the following steps:

 

1. Load both source tables into Power Query 

2. Merge the tables using 'Full Outer' merge

... Read More