VizWiz

Launch, grow, and unlock your career in data
Showing posts with label background image. Show all posts

April 8, 2021

How to Create a Ternary Graph / Triangular Chart

, , , , , , , , , , , No comments
Ternary graphs visualise the ratios between the three variables. A ternary graph requires three metrics, plotted as a triangle, where the sum of all three variables adds up to a constant. You can think of it as a three dimensional scatterplot. 

Each dimension is plotted based on its relative variance (on a scale of 0%-100%) to the largest value within the dimension. 

A value plotted near the top would indicate a weighting towards the variable at the top. Likewise, for the bottom right, a value plotted there would indicate a weighting towards the variable that was plotted on the bottom right. A value in the middle, indicates the dimension is balanced across all three variables.

Download the Car Sales mock data set here. Download the triangle I used as the background image on the chart here.

January 11, 2016

Makeover Monday: Stephen Curry Hates Mid-Range Jump Shots

, , , , , , , , , , , 6 comments


This week's Makeover Monday looks at this simple stacked bar chart from Sports Chart of the Day:


What works well:

  1. Nice labelling on the axes; this makes it clear what we data is displayed
  2. Nice annotation of the point of the chart


What could be done better:

  1. Needs a better title
  2. Needs to incorporate shooting % so that I can better understand the relationship between shots taken and shooting %
  3. Group together all shots over 30 feet
  4. Find a better way to compare the number of shots taken on each range. I find the stacked bars hard to compare within in a shot distance.
  5. Make the different shot ranges more clear, e.g., what defines a long 2?
  6. Provide a summary
  7. How are Curry's shot selections changing over time?


With these considerations in mind, here is my my makeover of the chart:


Note: If you'd like to participate in Makeover Monday, check this link for the details.

November 10, 2015

Tableau Tip Tuesday: Background Images, Customizing Object Locations & Images Inside Donuts

, , , , , , 6 comments
This week’s tip is quite a bit longer than normal, but that’s because I had several things I wanted to cover. Essentially, I wanted to show you how I built this viz for Dear Data Two.

The video covers:

  1. How to add a background image
  2. How to create donut charts with an image in the middle
  3. How to use point annotations to find the precise locations for placing objects

I hope you enjoy the tips; it was a lot of fun making this viz. Click here to see my write up for the Dear Data Two project.

December 23, 2014

Video Tip: How to quickly add labels to background images in Tableau

, , , , , , , 5 comments
I don't use background images often in Tableau. In fact, I never knew how to REALLY use them until I went to Tableau Trainer Certification with Molly Monsey, trainer extraordinaire at Tableau. With Molly's permission, I am sharing with you the super simple way that she showed us how to add labels to background images in Tableau.

First, here is the video and farther down the page are summarized steps with screenshots.


Step 1: Open the background image in a tool like Snagit to get the dimensions. Write the dimensions down.


Step 2: Create a data source. In this example, I created the outline of the data source in Excel and left the X/Y coordinates blank.


Step 3: Connect to the data source created in step 2 in Tableau.

Step 4: Change the data type for the X & Y fields to Numbers and move them to the measures area.

Step 5: Add the X field to the Columns shelf and the Y field to the Rows shelf.


Step 6: Add the background image by going to Map => Background Image => [Sheet Name]. Choose the image and enter the dimensions that you wrote down in step 1 in the Right and Top boxes respectively.


Step 7 (optional): Fix the axes to the size of the image.



Step 8: Hide the axis headers.

Step 9: Drag the Name field to the Label shelf.

Step 10: Annotate a point with the X/Y coordinates.


Note how this looks after you hit OK.  You can now move the end of the arrow around to get the coordinates of any point in the image.


Step 11: Move the end of the arrow around to each place in the image that you want to place a label and enter those X/Y values into the Excel spreadsheet. Save the Excel spreadsheet.


Step 12: Refresh the data source in Tableau and the labels will magically appear above the heads of each person.


Step 13: Remove the annotation.

Step 14: Change the Mark Type to Text and format the text as you see fit.  That's it!


You can download the Excel file here and the Tableau workbook here.
Subscribe to: Posts ( Atom )