Show multiple series from different tables in same line chart

[shaunguyver]

I have several data sets, all of which have the same column layout:

• Property Name
• 2015 Cost (£)
• 2016 Cost (£)
• 2017 Cost (£)
• 2018 Cost (£)

Each data set represents a different kind of cost. One data set is 'rent', another is 'security costs', etc. But, they're all financial and have the same column layout.

I want to create a line chart that shows each of these costs as different series. I am able to do this for each data set individually by unpivoting the columns. But when I place more than one value into the line chart (from another data set), it simply puts a line through the chart that isn't correct for the data.

Any help would be much appreciated,

Thanks

[Anonymous]

@shaunguyver Can you post a screenshot of sample data?

[shaunguyver]

Thanks for your quick reply - the first screenshot is an example of the Excel data my data sets are feeding from. The second screenshot is the data set in query editor once it has been un-pivoted so that I can create line charts.

[Anonymous · Accepted solution]

@shaunguyverYou could add a new column to each of your facts(sheets) which tells the category(i.e. Rent etc) and then union all the facts into 1 table. When you are drawing the line chart after this you can add the category in the legend field.