Grouped Bar with Line Graph when series in multiple columns
I know that the Grouped Bar with Line Graph requires one column for each of the "series", X axis, Y axis
I have the following table:
Date; Operation type; Operation amount; Rate
3/28/2018; Withdrawal; 1,000; 4%
3/29/2018; Deposit; 800; 3%
What I have built is a grouped bar with shows the following:
But I also want to see the line above the chart showing what was the rate on each date.