February 23, 2021
Four Methods for Creating a Seismogram
February 22, 2021
#MakeoverMonday Week 8 - Protests Against Limiting Abortion Rights in Poland
February 16, 2021
Understanding Table Calcs vs LODs: Explained with a Slope Graph
February 15, 2021
February 9, 2021
How to Assign Highlight Colors to Palette
February 8, 2021
#MakeoverMonday Week 6: Why Are Women Perceived to Be Unequal to Men?
Wow! What a fun #WatchMeViz that was! I iterated through 16 charts and then when the idea solidified, there was some great conversation and feedback on the chat to help me get to the end. I find survey responses quite difficult to visualize, so instead of getting frustrated, I thought about all of the ways I can compare data to see if anything would work.
Most importantly, thank you to all of your on the live chat. It makes a huge difference to me and I love getting your feedback and questions along the way. You make me better. You can find the final visualization below the video.
February 4, 2021
How to Add Zeros for Missing Time Series Data
February 2, 2021
How to Create a Trellis Chart in Seven Steps
Trellis charts are a version of a small multiples chart that organizes the dimensions in the view across a grid. In this tip, I show you how to create a trellis chart that will work even when you are missing data.
Trellis / Panel Chart Calculations
//Columns
(index()-1)%(round(sqrt(size())))
//Rows
int( (index()-1)/(round(sqrt(size()))))
Steps
- Create the column and row calcs
- Create a custom date
- Place custom date on columns, measure on rows and dimension on detail
- Place column on columns, row on rows, and custom date on detail
- Ensure dimension is above date on detail shelf
- Change custom date on columns to ATTR
- Configure table calcs
- Check both the Dimension and the date field date in order
- Ensure the dimension is above the date field in the Specific Dimensions section
- Set "At the level" to the dimension
February 1, 2021
#MakeoverMonday Week 5 - Renewables vs Fossil Fuels in Europe
ORIGINAL CHART
WHAT WORKS WELL?
- The colors are perfect for the topic.
- I like the labels on the ends of the lines.
- The tooltips are very responsive and color-coded to match the line.
- The title and subtitle are informative and give good context.
- The slightly lighter shading of the axes labels make the chart stand out more.
WHAT COULD BE IMPROVED?
- Make the dashed lines solid.
- Format the percentages in the tooltip to one decimal place.
MY VERSION
January 26, 2021
Three Methods for Creating Bar Charts that Fill to 100%
January 25, 2021
#MakeoverMonday Week 4 - Coal Production in India
- Watch Me Viz - https://youtu.be/ur3Vhs7Ceck (also below)
- Tableau Workbook - http://bit.ly/MM2021W4
What could be improved?
- There's no title.
- The District names are way too small. My old eyes can't read it.
- I don't understand the sorting. I would pick one of the metrics to sort by.
- The comparisons need to be more clear, if that is the intent.
Watch Me Viz
Final Dashboard (click to interact)
January 19, 2021
How to Apply Formatting Across Worksheets
January 18, 2021
#MakeoverMonday Week 3 - The World is Getting Warmer
This week's viz to makeover reminded me of a very similar (almost exactly the same) data set that we used for Makeover Monday in 2016. Here's the original viz:
Honestly, it's absolutely fantastic. It's one of the best examples of scrollytelling I've every seen. Check out the original here.
Since I had explored this data set before, I know pretty quickly what I wanted to do. During Watch Me Viz, I went ahead through many iterations of working with time series data; they're all available in the workbook. Watch the video here (or below).
Here's my final viz. Each dot represents a month and the line represents at 10-year moving average. Each mark is compared to the 1951-1980 median. Click on the image to view the viz on Tableau Public.
January 13, 2021
How to Create a Candlestick Chart
What is a Candlestick Chart?
A candlestick chart is a style of financial chart used to describe price movements of a security, derivative, or currency. Each "candlestick" typically shows one day, thus a one-month chart may show the 20 trading days as 20 candlesticks. Candlestick charts can also be built using intervals shorter or longer than one day.It is similar to a bar chart in that each candlestick represents all four important pieces of information for that day: open and close in the thick body; high and low in the “candle wick”. Being densely packed with information, it tends to represent trading patterns over short periods of time, often a few days or a few trading sessions.~ Source: Wikipedia
In this tutorial, I show you how to build a candlestick chart in Tableau. They are built as Gantt charts with a couple of simple calculations. Follow along by downloading the data set here.
January 11, 2021
#MakeoverMonday 2021 Week 2 - Women Die More Quickly Than Men From HIV Infection
I must admit that I REALLY struggled with this data set. I could have easily just compared males vs. females by country and year, but it seems we've been doing that over and over again. I looked to explore the data and thought a connected scatterplot would look nice, but it didn't.
Fortunately Michel Mahon proposed looking at the lag between the year of HIV infection rate and death. Morbid yet interesting analysis. It took me a while to get the calcs working; I'd recommend you build your view as a table to verify the calcs when you're not sure if they're correct. In the end, thanks to Michel's suggestion, I created a slope graph that compares the lag in years for both men and women.
As the documentation suggested, women die more quickly than men.
Below are both my visualization and the Watch Me Viz session on YouTube. Thanks for tuning in!
January 3, 2021
#MakeoverMonday 2021 Week 1: Quiet Streets & Clean Air - Americans Are Getting Outdoors
Back in March 2020 when COVID lockdown started in the UK, the streets were amazingly empty, the air got fresher and I saw more and more people outside. You could hear birds chirping on streets you never would have before. And we could ride our bikes right down the middle of the road since there were no cars. The lack of cars was glorious! (COVID isn't of course).
For 2021, #MakeoverMonday gets started with a simple graphic that compares pedestrian and bicycle counter stats for 2019 and 2020 at 31 counters across America. The data is collected by the Rails to Trails Conservancy, and you can learn more about the data here.
ORIGINAL VISUALIZATION
WHAT WORKS WELL?
- A line chart is a good choice for time series data.
- The colors are easy to distinguish.
- The grid lines help guide the eye across the view.
WHAT COULD BE IMPROVED?
- Include a more impactful or descriptive title. What is it about?
- Why are thee weeks missing on the x-axis yet the lines go the full year (or appear to)?
- The lines could be labeled directly so that you don't have to refer to the color legend to know which lines represents which year.
MY MAKEOVER
December 17, 2020
How to Create a Dot Matrix Plot
Dot matrix charts are useful for visualizing the distribution and frequency of discrete data. They help you understand the scale and proportion. The purchase is to understand how many, not how much.
In this example, I'm using two colors to distinguish new vs. used cars. However, if you have only one variable or category, then stick to one color.
Resources:
- Workbook - https://bit.ly/DotMatrixPlot
- Data set - https://data.world/vizwiz/car-sales-mock-data
December 8, 2020
#TableauTipTuesday: How to Sort a Chart with a Parameter Action
- Build the chart
- Create a parameter
- Create a calculated field to sort the bars, then sort the Region field.
- Create de-highlight calculated field and place it on the Detail shelf
- Create a Parameter Action
- Create a Highlight Action
- Turn on Animations
- How to Reorder a Chart with a Set Action - https://www.vizwiz.com/2020/11/reorder-stacked-bars.html
- Data Set - https://data.world/vizwiz/superstore-20203
December 1, 2020
How to Create an Evenly Distributed Butterfly Chart
A Butterfly Chart is (typically) a bar chart where two sets of data series are displayed side by side. The purpose is to allow you to compare the two data series across a dimension.
Here is an example of a butterfly chart I created for Makeover Monday.
Notice how I have zero at the center and the scales are the same on either side of zero. This helps show how the chart "leans" to one side or the other.
The comparisons would be more difficult to see if the left and right hand sides of the butterfly did not have the same axis scale. In this video, I show you how two examples for creating a butterfly chart.
November 26, 2020
How to Create U.S. Electoral Cartograms
I don't remember how I came across the set of cartograms I'm going to show you how to create. Alas, I wanted to recreate this mesmerising set of cartograms that Noah Veltman created based on election maps from various media outlets.
- X on the Columns
- Y on the Rows (and reverse the axis)
- Set both X and Y to AVG
- Change the mark type to Polygon
- Add the Path field to the Path shelf (this tells table how to connect the edges of the polygon)
- Add the State field to the Detail shelf