Home

Charts and Visualizing Data

30 Conversations

Latest Activity

Custom List Message Item

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

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
309 Views
9 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

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
75 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
46 Views
0 Reply

India map chart.png

 

All states except Telangana are mapped, please check.

 

India map chart.png

Read More
43 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
98 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
75 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
77 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
573 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
72 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

41 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
188 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
96 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
272 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
208 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