Home

Charts and Visualizing Data

39 Conversations

Latest Activity

Custom List Message Item

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
22 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
112 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

24 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?

35 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
41 Views
1 Reply

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

17 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
48 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

42 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
61 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
510 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
62 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
114 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
78 Views
0 Reply

India map chart.png

 

All states except Telangana are mapped, please check.

 

India map chart.png

Read More
84 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
109 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
100 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
91 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
883 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
104 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

Is it possible to have a setting that when the Graphs with a black background are printed, the change to lighter colors, say a white background and then possibly the bars and lines also have to change?

 

Thank you

Simone

60 Views
0 Reply

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
320 Views
1 Reply

Don't know if you solved this, but I think this is what you are looking for? http://www.exceldashboardtemplates.com/how-to-easily-create-a-stacked-clustered-column-chart-in-excel/

Read More

I need to create 25 different graphs (All on one sheet) from one Pivot table's data (different sheet), without the pivot table creating multiple different pivot tables.

Also, the graphs need to update every month when the pivot table is updated.

 

How is thi

... Read More
120 Views
1 Reply

Hi Simone,

 

On one Pivot Table you may bild as many different charts as you need, all of them will be updated together with Pivot Table.

 

In the Ribbon ->PivotTable Tools->

... Read More

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
300 Views
12 Replies

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

 

Best, Oliver

I have a column with location data (5 different locations) and when I choose a location the cells in that column change fill colour. This is easy. What I want to do is then change the fill colour in every cell along the row in a table (of about 15 columns

... Read More
242 Views
11 Replies
Select the cells which you want to format.
Example A1:Z100

Go to Conditional formatting ->
Use a formula to determine which cell to format.
Enter the formula
=IF($A1="India",1... Read More

 

Conditional Formatting will only apply colors pre-defined by you.

 

By creating a Macro, it is possible to apply customized colors will be applied to the respective rows (

... Read More

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