How to create top 5 chart in Tableau

I have revenue data of 57 Brands for 7 years in excel sheet as shown below:


To create top 5 charts first I will load data into tableau from excel file. Then drag Brand into filter shelf. You will get filter window pop up. Goto tab 'Top'->select by field option->enter number 5->Select column revenue->Hit ok.


We have created filter, now just drag Year into columns shelf and Revenue into row shelf and Brand into colors as shown below:


here is your chart ready every line series represent a brand 

Now if you want to show this as Stacked chart so you find it disabled. 



Just right click on Year -> select Discrete chart will get converted into stacked bar chart.





Other top chart options will also get enabled in 'Show Me' menu.


Comments

Popular Posts