Weave a web for spider charts on Tableau with the help of Excel

Weave a web for spider charts on Tableau with the help of Excel

Weave a web for spider charts with the help of Excel. At the end of last article “An Easy Way to Draw Spider Charts on Tableau — Part I”.

At the end of last article “An Easy Way to Draw Spider Charts on Tableau — Part I”, we left a question: how to provide a “web” background for our “spiders”.

There are many tutorial articles and videos to teach people how to draw a radar background using calculations on Tableau, but I found them a little bit so complicated and hard to understand. I developed this easy way to get a background “web” from Excel and imported the “web” as a picture into Tableau. It’s very easy and straightforward to follow, so why not try to start “weaving your own web” from now?

In this article, I will still use the same university ranking example in Part I to help you understand the steps better.


>>> Step 1: Draw a “web” at Excel

Since we have 6 categories of [Qualities], we should weave a web consisting of 6 corners at Excel as well.

Open an Excel > Copy the 6 qualities and their scores and paste them at Excel > “Insert” > “Charts” > “Radar”

Image for post

Delete all the titles, axes and labels on the chart > Delete all the score numbers

Image for post

Copy the chart at Excel and paste it as a picture at Microsoft Word > Save the web picture to your local device

Image for post

Image for post


>>> Step 2: Import the “web” into Tableau

In the radar chart sheet, click “Map” *> *“Background Images” >** “Add Image…”**

Image for post

Find your web picture in “Browse” > Select a proper level of “Washout”

data-visualization excel data-science tableau data analysis

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

Tableau Data Analysis Tips and Tricks

Tableau Data Analysis Tips and Tricks. Master the one of the most powerful data analytics tool with some handy shortcut and tricks.

Exploratory Data Analysis is a significant part of Data Science

Data science is omnipresent to advanced statistical and machine learning methods. For whatever length of time that there is data to analyse, the need to investigate is obvious.

50 Data Science Jobs That Opened Just Last Week

Data Science and Analytics market evolves to adapt to the constantly changing economic and business environments. Our latest survey report suggests that as the overall Data Science and Analytics market evolves to adapt to the constantly changing economic and business environments, data scientists and AI practitioners should be aware of the skills and tools that the broader community is working on. A good grip in these skills will further help data science enthusiasts to get the best jobs that various industries in their data science functions are offering.

7 Best Tableau Online Courses for Data Science and Visualization

Also Includes courses to become Tableau Certified Associate and Desktop Specialist. In the era of Big Data and Data Science, Data Visualization and Analytics have become really important. Data visualizations like dashboards and charts help you to better understand the data and provides you insights.

Data Analysis Using Excel

Data Analysis Using Excel - Learn useful Excel techniques and create powerful dashboard for exploratory data analysis