Data Visualization How-To: Comparative Bubble Charts in exel

I copy pasted the full article from this site. Please visit the original site: Data Visualization How-To: Comparative Bubble Charts   Today we will walk through the custom creation of a bubble chart together.  We will use the following common cooking measurement data: 1 tsp. 1 Tbsp. is 3x’s bigger than a tsp. ¼ cup…

Graduated and Proportional Symbol Maps using QGIS 2.14

Graduated and proportional symbol maps are a class of maps that use the visual variable of size to represent differences in the magnitude of a discrete, abruptly changing phenomenon, e.g. counts of people. Like choropleth maps, you can create classed or unclassed versions of these maps. The classed ones are known as range-graded or graduated…

QGIS: How to make a hit map or Choropleth map?

Choropleth maps are maps that are coloured or shaded according to a discrete scale where each shade represents a measure or range of an attribute. Areas within a region, such as postcode or local government area, are shaded according to the discrete scale. Examples in epidemiology include population or population density, outbreaks, prevalence, and incidence…

Find duplicate values in two columns in Excel

To compare two columns and find the same values, you can use a formula. It will reduce your time to manually find any value of one column to any value of the other column. The magic formula is: =IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),””,A1) This formula will compare any value in C1 cell to C5 cell to any value in…