good morning

this can be done with a dual axis plot but it is involved for a newbie

a lot will depend on the data structure and the number of data sources -

please post your twbx workbook ( even with dummy data) so we can see what you are doing

also

Tableau has excellent free video training at Tableau Training: View Training Courses

it will take you from getting started through advanced calculations

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

Hi

I have taken your data - cleaned it - loaded it into tableau - pivoted the dates - (they should be real dates and not strings) and then split out the month and year - but what you are asking is beyond our purpose here -

you can take what is attached and then start working it into the chart you want - - your dimensions in the chart are not the same as in the excel file you sent

clearly you need training - you can start with the free on-line training noted above - also consider either a Tableau consultant or mentor -

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

I took a second look at the data and used the data you pivoted in excel

it cleans up the chart a lot BUT  it still needed to be pivoted in Tableau

see the attached

You need REAL dates (not strings) in the data set -

jim

thanks

I appreciate the awards

Please look into that training

once you have done that there is also a mentoring group that you may want to consider 

http://www.mentoringmeetup.com/

Jim

Hi

first to your question

that line has to be created on a dual axis chart as yo have done - BUT - the issue you face is that you are trying to draw a continuous line on a discrete axis - each of the bars establishes a separate position (discrete) on the month (discrete) axis and you are trying to draw continuous line across all of the month/measure combinations

this would be easy  with  a single continuous date dimension and a stacked bar

but the contiuous dimension ad side by sid breaks the line chart into points

Jim

BTW  using the pivot table in excel OK as a one - off - but you want to load all the low level data into tableau and do the pivot there - else you will have to create the pivot in excel every month ad then reload in tableau

that is just a percent of total cal made up to illustrate a point - it does not pertain to your data