Excel charts gallery by FrankensTeam

LinkedIn

Welcome to the E90E50charts!

Our gallery is opened to show you all the Microsoft Excel charts and data visualization tools created by the members of the FrankensTeam in the past years. We illustrate each work with one picture linked to the original article and we also provide a link to the downloadable template file. 

Feel free to add our link to your work! 

If you like our work, we would be happy to read your thoughts in the Visitor's book, this is the only reward for our work. 


The Old Version of E90E50Charts

Visitor's Book

Alps chart

Violin plot report

Moon phases

Spiral chart - New York Times case

Spiral chart - Area chart version

Spiral chart - Sewing pins version

Spiral chart - Double color version

Network Graph - Excel Challenge 

Multiple Waffle Chart

Sawtooth Chart by Romain Vouillemot - Variation with bars

Violin plot black and white

UpSet Plot - SWD challenge

Violin plot color

Multiple Pie/Donut Chart

Sankey Diagram

Ball of Wool Chart - Surface area and population of US States - SWD challenge

Archimedean Spirals Map - Surface area and population of US States 

Horizon Graphs - in only one xy scatter plot Excel chart

World Population Prospects 2022 

Migration Waves - Strong labor markets draw migrants

UpSet Plot - Vertical version step by spet guide

Migration Waves - Movement of people between countries

Minimalistic Ring Chart

Spiral Multichart - Air alerts from Russian attacks occurred in the last week in the Ukrain Oblasts

Slope Chart with Bars in only one Excel Chart

Calendar of air alerts for Russian attacks in Ukraine

The Word in 2100

IBCS Ispired Column Chart

World Population Prospects 2022 

Oscar Director in 1929-2023

Poverty's Factors in the USA

Pie (or Donut) and bar chart 

The duration the daylight in Kyiv 2023 

Column chart with evidence of a percentage value 

Pie (or Donut) Chart with Dots

Coxcomb Chart - Short Guide

Scaling Issues IBCS ispiration - Creative solution

Africa Cup of Nations - Partecipant, winners, second and third places in all year (1957-2021) 

Grid for multiple charts - step by step guide


Multiple Area Chart - How did America vote?

IBCS Ispired Bar Chart



Multiple Dots Chart - US House of Rapresentatives by State

X-Y Scatter Plot - Seating layout in the US House of Representatives and the US Senate

Multi Donut Charts on US Map - 2020 US Presidential Election

Column and Bar Chart with Dot Scatter - Step by step guide

Carbon Tax, a datavisualization for Scientific American by Sonja Kuijpers

Carbon Tax, a datavisualization for Scientific American by Sonja Kuijpers - version with filled shapes

Coxcomb Chart style IBCS

Variable length Coxcomp Chart

Coxcomb Chart multi series

The timespan from millionaire to billionaire and to current patrimony - Original Viz by Sonja Kuijpers

Multi Donut chart to show percentages even above 100% - List of countries by General government gross debt (Percent of GDP, 2022)

Multi Bar Chart Variance - IBCS Style

Multi Pie Chart Variance Bars on US Map - IBCS Style

Donut chart to show percentages negative and positive over 100%

Multi Pie Chart Variance Bars on Grid - IBCS Style

Multi Bar Chart - IBCS Style

Donut chart to show percentages even above 100% - version with donut in the foreground

Square chart with 4 values

Donut chart to show percentages even above 100%

Square 45° chart with 4 values on US tile map

Square chart with 4 values on US tile map

Mekko Chart - Racial breakdown of population by state

Dashboard Temperature (°C), Precipitation (mm) and Energy Consumption (kWh)

The map of Napoleon's Russian campaign by Charles Joseph Minard

Column Chart - (absolute value and % value case 1)

Column Chart - (absolute value and % value case 2)

Musical Note  Chart

Postal codes of Italy

Percentages over 100%

Helix Chart

Stacked Column Flow Chart in Excel 

Dinamic Stacked Column Flow Chart in Excel - Version 2

Staked Column + 100% Donut + Clustered Bar Chart

Staked Column + 100% Donut + Clustered Bar Chart

100% Donut + Clustered Bar Chart with total

100% Donut + Clustered Bar Chart with total - version 2

Primary Energy Production Estimates US

Migration Flow Chart (Chord Chart)

Column Chart with Shadows

Column Chart with Shadows - Scaling Issues 

Jitter Plot Charts 

Out of range values Column chart IBCS style - Sort values 

Out of range values Column Chart IBCS style 

Out of range values Bar chart IBCS style - Sort values 

Towers of Italy by height and slope

Tilt Bar and Column Chart

Tilt Bar and Column Chart

Tilt Bar and Column Chart

Combine Bubble and xy scatter line chart in Excel

Excel LAMBDA - Custom Functions by Hazem Hassan

 Download

Types of Data Professionals - Radar Chart

The Trilogy Meter - Multi-Column Chart in Excel

Simulated Dendrochronology - Air attack alarms

Simulated Dendrochronology - Air attack alarms with multi radar chart

#30DayChartChallenge | Day 19 | Dinosaurs

World daily average global surface air temperature since 1940

Excel LAMBDA for combinatorics

#30DayChartChallenge | #Day16 | weather 

2023 IQAir World Air Quality Report

Sketchy Column and Line chart in Excel 

Sketchy Pie chart in Excel 

Sketchy Radar chart in Excel