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”
Delete all the titles, axes and labels on the chart > Delete all the score numbers
Copy the chart at Excel and paste it as a picture at Microsoft Word > Save the web picture to your local device
>>> Step 2: Import the “web” into Tableau
In the radar chart sheet, click “Map” *> *“Background Images” >** “Add Image…”**
Find your web picture in “Browse” > Select a proper level of “Washout”
Tableau Data Analysis Tips and Tricks. Master the one of the most powerful data analytics tool with some handy shortcut and tricks.
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.
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.
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 - Learn useful Excel techniques and create powerful dashboard for exploratory data analysis