Clustered Stacked Column Chart with Line graph

[non23]

Hi guys, is there a way to have a single-point in the line graph for this kind of graph?

Gross Margin is creating two points for each type which is Cost and Sales. Is there a way to make it into one point instead?

Here's my sample file: https://drive.google.com/file/d/185aS8iD-c9ifUn7HIqCOBsx7iGYXXcJL/view?usp=sharing

[lbendlin · Accepted solution]

You can either have single data points or you can have lines.  You can't have both.

With the way you are structuring your y axis hierarchy that's the best you can do with the standard visual.  Consider refactoring your visual, or using custom visuals like Deneb.