Trend Charts are very good visualization technique in my earlier post Trend Chart in Tableau. I have used Tableau for the Trend Chart. In this tutorial we’ll learn how to make Trend Charts in Excel and use of Alt Key Codes and Paste Special in Excel.
While working on other’s Excel worksheet sometimes we need to find which columns are formula column, we can find while scrolling to each column but the work can be very tedious if we have more than 10 column. Today we’ll be learning to find the formula column in entire sheet having large number of columns (more than 100) in one go and one more very very useful function F5. I will make a separate tutorial for F5 function.
While working on a Project somewhere I needed to count the number of words in a particular cell. In this tutorial we’ll be learning to Count the number of words in a cell in Excel. The tutorial explained in step by step and worksheet is attached.
Some time we just need to visualize data that shows Year over Year (YOY) growth so we don’t have to drill down the data more for the explanation in others words for better and easy understanding of YOY growth we need some better visualization techniques.
Trend arrows are one of the best visualizations for the YOY growth like we have in stock market trending arrows on daily basis.
In this tutorial we’ll be learning to make create the Trend arrows chart in Tableau.
Workbook is attached with the step by step worksheets
Sometimes we need our own custom Shapes or pictures to use in the Tableau Chart. In this tutorial you get to learn how to add custom shapes in Tableau (Workbook and Data-set are attached).
Donut Charts can be an effective way to show the comparisons in a unique way (Tableau workbook can be find in the end of the post).
I will be using Sample-store data(available on Tableau desktop as sample data).
Today we’re going to learn about Dual Axis Chart which is a one of the best methods I like. I will try to explain in very easy steps and also you can find the Tableau Workbook at the end of the post.