I have a problem with chart that needs to represent 2 data tables with 2 lines. First table consists of dates (everything is in columns) and numbers (around 900 rows of data). Second table is identically structured with a difference of only having 5 rows of data.
I've thought if I create first chart that somehow second line (second table data) would find exact dates on x axis from table one and that line 2 would be correctly positioned.
Maybe my explanation is a bit confusing so attached file should help.
BTW I've tried many different combinations and nothing. Finally I've concluded that my approach is not right.
Thanks.
DoubleLineChart.xlsx
Bookmarks