First, Tableau is not a spreadsheet application like Excel. It is an application for reporting. Don't try to make Tableau into Excel as it will fail. Excel's primary purpose is spreadsheets.
Second, Tableau should be able to do that type of chart (I want to say by using a dual-axis but I'm not a Desktop expert) and I'm sure some of the experts here will show you how. However, including a packaged workbook (.twbx) would really speed up the help you'd get.
Ok thanks I will get the twbx ready.
Or you can attach excel file as a starting point.
Enclosed TWBX. (in my first comment)
I hope this can help!
In advance thanks a lot
This is a typical example where the Excel user is disappointed at Tableau as initial impression.
As easy execution, only sheet 2 or sheet 3 is available.
Excel is pretty flexible for these combination view but Tableau is not good at this specific combination chart.
(Multiple Bar x multiple line)
Technically side-by-side Bar chart requires dimensions in same pane (in this cae year 2015 and 2016).
At the same time Tableau cannot draw the line chart beyond pane.
This is relatively small disadvantage as interactive chart, but I agree this is big disadvantage as still picture....
More complicated solution is cheating Week ID.
(But I don't recommend this method for new users.)
if [Year Header]=2015 then [Week ID]-0.1
elseif [Year Header]=2016 then [Week ID]+0.1
Graph WEEK and YTD_SM_10.0.twbx 52.8 KB
Thanks a lot!
I was able to re use what you did. Very helpful.
Glad you got it to work...now go show that trainer who's da boss!
I marked Shinichiro's answer as Correct because he is the one who actually answered your question and deserves the credit, I simply opened the door for one of our many experts to come in and help you
Thank you Toby and I'm glad to help these questions