Home

Charts and Visualizing Data

90 Conversations

Latest Activity

Custom List Message Item

Hello everyone,
Can somebody help me in creating a visualisation as shown in the image below. I have all the required data with me for a different parameter. Need it for a college project. Screenshot (12-Feb-2018 3_13_53 PM).png

Read More
37 Views
4 Replies

Hi Mayank,

First, there is no default chart in Excel to get that result. However, it is possible to built it peace by peace.

For that, you have to create two charts, a "S

... Read More

I have a pivot table with 3 columns of values. Column 1 is the entire population, and columns 2 + 3 are segments of that population with filters applied. I want to create a stacked column chart in excel where columns 2 + 3 are part of Column 1. Instead, i

... Read More
22 Views
3 Replies

Hi George,

 

I guess you need clustered column graph, not stacked one. For clustered columns format Series Overlap as 100%

Best Response confirmed by George King (New Contributor)

Have a specific question for analyzing subgroups, I'm not sure if this falls into a conditional formatting category, but here it goes. Here's a hypothetical for what I'm trying to do.

 

I have three columns of data in my worksheet

 

Customer age (quantita

... Read More
69 Views
1 Reply

Hi Fred,

 

SUMPRODUCT could help.

=SUMPRODUCT((A2:A23<=10)*(B2:B23="chocolate"))
=SUMPRODUCT((A2:A23<=10)*(B2:B23="chocolate")*(C2:C23=2))
=SUMPRODUCT((A2:A23<=10)*(B2:B2
... Read More

Hi experts,

I want to conditionally format the contents of the cells in one column based on it if mates the contents of the cell in the column next to it.

There is an order number in the first column, and I want to format the batch numbers in the second c

... Read More
35 Views
2 Replies

Hi Hayley,

 

You may apply two rules to your column B, for the green

=ISNUMBER(SEARCH($B3,$A3))

and for the red

=NOT(ISNUMBER(SEARCH($B3,$A3)))

Just be careful with absol

... Read More

Dear experts,

 

I want to add a Data Bar in the YTD (Year To Data) spend column. I do not have enough space in the table so want to use the Data Bar to reflect the burn rate vs Plan.

 

So, in the below example the Data Bar in column E, which is based on t

... Read More
17 Views
0 Reply

I want to conditionally format a row one 1 of 3 colors depending on one of the cells in the row being at, above or below goal. I know how to do that--easy peasy. But I want to ignore formatting if a cell in that row that is part of the result is too low t

... Read More
29 Views
1 Reply

Hi Pati,

Please find bellow a solution.

To achieve your goal you have to create a customised conditionnal formating using a formule.

The important thing is because you wa

... Read More

i. 

I am plotting counties of the UK - specifically the South West of England. This includes Cornwall, Devon, Somerset and Dorset. Excel maps WILL NOT plot Devon, no matter what I call it. I have tried:

Devon

UK, Devon

Devon, UK

Devon, United Kingdom

Devo

... Read More
36 Views
2 Replies

Paul, did you try Devonshire?

Best Response confirmed by Paul T (New Contributor)

Hi. So new I don't know where, how or what to ask. Starting a spreadsheet with names, sales to these individuals and when. Plan to put the sales in randomly and then sort by date in that row, need the date and sale to stay together when sorted. Thanks

Read More
22 Views
0 Reply

If I have a sheet with numerous rows, where some rows logically fall into groups, Is it possible to create row groupings? Something like an example below with functionality to hide rows under the upper category. Not sure what this functionality is called.

... Read More
47 Views
1 Reply

Hi @Ella Foux,

 

Try Data->Outline->Group.

Hi,

I've a pivot table with hundreds of elements that have a indicator variating over several days. I want to sort, let's say the top 10 elements, for which this indicator present a bigger variation over the time. How can I sort them?

 

As an example, le

... Read More
28 Views
1 Reply
I guess you must somehow add a field to the source which represents the variation and add that field to the PT.

I am attempting to add the 3-color gradient scale conditional formatting:

 

If =C2 is <=20 the row should be red

If =35<=C2<=40 that row should be yellow 

If  =c2>=70 that row should be green

 

A separate format for:

and If =C2=90 that row should be gray

... Read More
42 Views
1 Reply

Hi Kaia,

 

Status numbers in your Sheet2 are stored as text, thus VLOOKUP returns text and that's why conditional formatting doesn't work.

NumberAsText.JPG

You may convert Status to numb

... Read More

Hi Everyone, I have built a great dashboard for my business. I have created Pivot Tables and from the tables I have created Pivot Charts. My only challenge is inability of my Workbook to save changes I've made to my charts. I want negative value to be inv

... Read More
55 Views
2 Replies

Johnbosco,

 

I believe that is a real bug,

 

I want to highlight the entire row if there is a date in cell J.  Or I can fill the entire worksheet and then unfill if cell J is blank.  Please help.

23 Views
0 Reply

Good morning.  Our firm concentrates on providing training for people with disabilities, and I have been developing Excel tools that allow visually impaired individuals to access spreadsheets using the JAWS add-on.  I use hyperlinks to assist the user to

... Read More
66 Views
4 Replies

Assuming you point each hyperlink to the top-left cell below each chart you could place this code in the ThisWorkbook module to have the chart floating with its top-left

... Read More

Office 365 w Excel 2016

Have a line graph that has numerous points in the "20" range and numerous points in the "100" range.  No points between 30 and 85 so I have a big white space and "busy" areas high -100 and low - 20 that I cannot expand since I have

... Read More
29 Views
0 Reply

I have made a line graph using the X and Y values on the left. I would like to add the X and Y values on the right as points (in a different colour) on this graph. i tried to do this by adding another line, but it didnt work because the X values are diffe

... Read More
19 Views
0 Reply

Hi All! I'm big on formatting but have recently had trouble as formatting effects storage size. In the past, I have used conditional formatting to apply shading to alternating rows in a table. As my data set began to grow (100k+ lines) this exponentially

... Read More
23 Views
0 Reply

Hi All! I'm big on formatting but have recently had trouble as formatting effects storage size. In the past, I have used conditional formatting to apply shading to alternating rows in a table. As my data set began to grow (100k+ lines) this exponentially

... Read More
20 Views
0 Reply

Hi everybody

 

I am a teacher in History of technology and History of ideas. I recently found out that you are able to make visual timeline charts showing historical developments by using the Map function in Excel. As an example, I tried to show the produ

... Read More
109 Views
5 Replies

You could try using the 1904 date system (File tab > Options > Advanced > When Calculating This Workbook), which seems to accommodate older dates. But it does so by addin

... Read More

Hello,

 

no, dates before 1/1/1900 are not supported in Excel. You could try using just the year number instead of full dates, but I'm not sure what time line functionali

... Read More

Hi,

 

I'm trying to conditionally format cells in column A based on their related to cells of the same row in column J.

Essentially if the date in column A is before the day in column J I want the cell to go green

If the date in column A is after the date

... Read More
61 Views
4 Replies

Hi Hayley,

 

You need to apply two rules, one for each color. For example, for the green

New rule-> Use the formula...

and

=$A1<$J1

applying to your range

 

Read More

I want to create a set of conditional formatting rules where if cells H1 to K1 add up to a certain sum, then highlight cell A1 a certain way, otherwise do nothing.  Then if H2 to K2 add up to a certain sum, then highlight cell A2 a certain way, otherwise

... Read More
192 Views
4 Replies

Kevin,

 

Do the following steps

  • Select cell A1.
  • Go to Home >> Conditional Formatting >>  New Rule.
  • From the New Formatting Rule dialog box select the rule type of (Use a
... Read More
Best Response confirmed by Kevin Burel (New Contributor)

I am using the latest version of excel for my spreadsheet at work I chart all of our electronic payments from insurance companies.  Today it will not let me type in a cell.  As soon as I go to type in the information it automatically kicks me to a random

... Read More
36 Views
0 Reply

I have a pivotchart for a document I use every work day and we add new data into it everyday. Everytime I refresh data it wipes out my formatting for the labels. Is there any way to set this to remain constant so all I have to do is click refresh data. 

Read More
24 Views
0 Reply

So i searched for hours on the Microsoft website but when i found something it did't match my excel version or my cause.

 

I want to make a table that has the following colomns:

Transactiontype(with a choice between income and expenditure)

Date

Descriptio

... Read More
32 Views
0 Reply

I have a large set of data that has daily data that I update weekly. I need to create a graph that automatically updates to show a line graph with the three most recent weeks trended as separate series. 

 

Example if it were week 44 I would need to it sho

... Read More
70 Views
1 Reply

Hi,

 

Format the source data of your chart as a table and the charts should auto-update.

 

Thanks,

Bala..