I’m probably not understanding the question correctly, but your mockup result doesn’t make sense to me in light of the data provided. If I understand correctly, the categories in your visual above represent your four measures. If that’s the case, then a line chart is not appropriate, since it implies a series of changes over time to the same variable. Instead, what you have are comparisons within and across categorical variables (share vs. insight). For that scenario, a clustered column chart makes far more sense to me than a line chart. See what you think:
In addition, I can’t tell what data in your table Series’ 1, 2 and 3 correspond to?
I hope this is helpful - happy to revise if I’ve interpreted this incorrectly.
Full solution file attached.