Sitemap
A list of all the posts and pages found on the site. For you robots out there is an XML version available for digesting as well.
Pages
Portfolio
Going much beyond the chart library to turn Excel into a data visualization tool.
Projects and experiments
Projects and experiments with real-world data.
Hi, my name is Jorge Camões, and I am a consultant in data visualization. See how I can help automate, connect and reveal what your data has to say.
Page Not Found
Page not found. Your pixels are in another canvas.
Posts
dashboards
portfolio
Beautiful But Terrible Population Pyramids
Stretching population pyramids to display 150 years of population change.
William Playfair, please meet Excel
Using Excel to recreate a 19th century landmark chart by William Playfair.
Excess mortality and Covid-19 deaths
Using a single chart, we can visualize the evolution of mortality in Portugal and its relationshiop with Covid-19 deaths.
Population distribution in Europe
Is it possible to visualize two million data points in Excel? It is, and it looks good!
Parts-of-a-whole: the fan chart
A false pie chart that puts proportions in perspective (it’s actually a scatterplot).
pt-tutorial-dataviz
shop
tutorial-dataviz
tutorial-datawrapper
tutorial-distributions
[Excel] How to make a simple bubble strip
Video tutorial on how to make a bubble strip plot in Excel
[Excel] How to make a vertical strip plot
Video tutorial on how to make a vertical strip plot in Excel
tutorial-excel
tutorial-flourish
tutorial-gaps
[Excel] How to make a vertical range dotplot with average
Video tutorial on how to make a dotplot range with mean in Excel
[Excel] How to make a range dot plot
Video tutorial on how to make a range plot in Excel
[Excel] How to make a vertical range dotplot
Video tutorial on how to make a dotplot with a vertical range in Excel
[Excel] How to make a slope chart
Video tutorial on how to make a slope bar chart in Excel
tutorial-kpi
[Excel] How to make a bullet chart
Video tutorial on how to make a bullet chart in Excel
[Excel] How to make a simple gauge
Video tutorial on how to make a simple gauge in Excel
tutorial-partofwhole
[Excel] How to make a 100% stacked bar chart
Video tutorial on how to make a 100% stacked bar chart in Excel
[Excel] How to make a bowtie plot
Video tutorial on how to make a bowtie plot in Excel
[Excel] How to make a doughnut chart with emphasized slice
Video tutorial on how to make a doughnut emphasizing a slice in Excel
[Excel] How to make a doughnut chart
Video tutorial on how to make a doughnut in Excel
[Excel] How to make a filled doughnut chart
Video tutorial on how to make a filled doughnut in Excel
[Excel] How to make a hemicycle plot
Video tutorial on how to make a hemicycle plot in Excel
[Excel] How to make a pie chart
Video tutorial on how to make a pie chart in Excel
tutorial-powerbi
tutorial-profiling
[Datawrapper] How to make a grouped bar chart
Video tutorial on how to make a grouped bar in Datawrapper
[Tableau] How to make small multiple bars
Video tutorial on how to make small multiple bars in Tableau
tutorial-ranking
[Excel] How to make an area chart pyramid
Video tutorial on how to make a population pyramid weth areas in Excel
[Excel] How to make a bar chart with negative values
Video tutorial on how to make a bar chart with negative values in Excel
[Excel] How to make a dot plot with arrows
Video tutorial on how to make a dotplot with arrows in Excel
[Excel] How to make a dotplot with positive and negative values
Video tutorial on how to make a dotplot with negative values in Excel
[Excel] How to make a simple dotplot
Video tutorial on how to make a simple dotplot in Excel
[Excel] How to make a bar chart with labels inside
Video tutorial on how to make a bar chart with labels inside the plot are in Excel
[Excel] How to make a Likert scale chart
Video tutorial on how to make a Likert scale in Excel
[Excel] How to make a line pyramid
Video tutorial on how to make a line pyramid in Excel
[Excel] How to make a simple lollipop
Video tutorial on how to make a lollipop chart in Excel
[Excel] How to make a bar chart with overlapping series
Video tutorial on how to make a bar chart with overlapping series in Excel
[Excel] How to make a Pareto chart
Video tutorial on how to make a Pareto chart in Excel
[Excel] How to make a population pyramid with bar charts
Video tutorial on how to make a population pyramid with bars in Excel
[Excel] How to make a bar chart with a reference line
Video tutorial on how to make a bar chart with a reference line in Excel
[Excel] How to make a bar chart with a reference marker
Video tutorial on how to make a bar chart with a reference marker in Excel
[Excel] How to make a simple bar chart
Video tutorial on how to make a simple bar chart in Excel
[Excel] How to make a bar chart with two series
Video tutorial on how to make a bar chart with two series in Excel
[Excel] How to make a vertical lollipop
Video tutorial on how to make a vertical lollipop in Excel
tutorial-relationships
[Excel] How to make a bubble chart
Video tutorial on how to make a bubble chart in Excel
[Excel] How to make a bubble heatmap
Video tutorial on how to make a bubble heatmap in Excel
[Excel] How to make a connected scatterplot
Video tutorial on how to make a connected scatterplot in Excel
[Excel] How to make a scatterplot with marginal frequencies
Video tutorial on how to make a scatterplot with marginal frequencies in Excel
[Excel] How to make a simple scatterplot
Video tutorial on how to make a simple scatterplot in Excel
[Excel] How to make a split scatterplot
Video tutorial on how to make a split scatterplot in Excel
tutorial-tableau
tutorial-timeseries
[Excel] How to make an area chart
Video tutorial on how to make an area chart in Excel
[Excel] How to make a line chart with a horizontal highlight
Video tutorial on how to make a line chart with horizontal highlight in Excel
[Excel] How to make a line chart with custom markers
Video tutorial on how to make a line chart with markers in Excel
[Excel] How to make a tensile line chart
Video tutorial on how to make a tensile line chart in Excel
[Excel] How to make a line chart with vertical highlight
Video tutorial on how to make a line chart with vertical highlight
[Excel] How to make a line chart with xl markers
Video tutorial on how to make a line chart with extra large markers in Excel
[Excel] How to make a simple line chart
Video tutorial on how to make a simple line chart in Excel
[Excel] How to make a step chart
Video tutorial on how to make a step chart in Excel