When I select dual-axis, both the axes get same chart type. How can I make one line and another bar chart
Let’s say we need to create a dual-axis for segment vs sales vs quantity. When first you will make the chart, it will look like below where both quantity and sales are circle marks.
Now, this doesn’t make much sense and so we can change the chart type. We can make sales as a bar chart just by selecting from the marks section of sum(sales) from the dropdown.
This way you’ll be able to make the required changes to the dual-axis graph.