Hi @JLLLL,
I think the combo chart works the best. Amazon QuickSight supports the following types of combo charts:
- Clustered bar combo charts – display sets of single-color bars where each set represents a parent dimension and each bar represents a child dimension. Use this chart to make it easy to determine values for each bar.
- Stacked bar combo charts – display multi-color bars where each bar represents a parent dimension and each color represents a child dimension. Use this chart to make it easy to see relationships between child dimensions within a parent dimension. This chart shows the total value for the parent dimension and how each child adds to the total value. To determine the value for each child dimension, the chart reader must compare the size of the color section to the data labels for that axis.
Use a combo chart only if you want to show a relationship between the bars and the lines. A good rule of thumb is that if you need to explain how the two chart types relate, you should probably use two separate charts instead.
Because each chart works differently, it can be helpful to understand the following points before you begin:
- The data points in each series render on different scales. Combo charts use a scale based on the maximum value for the selected measure.
- The distance between the numbers on the axis won’t match between the lines and bars, even if you select the same scale for each chart type.
- For clarity, try to use different units for the measure in each data series.
For more Information - [Click here]
(Using combo charts - Amazon QuickSight)
In case you need further assistance, please create a sample dashboard with sample dataset showing your problem state using Arena and post it here. (Details on using Arena can be found here - QuickSight Arena
We hope this solution worked for you. Let us know if this is resolved. And if it is, please help the community by marking this answer as a “Solution.” (click the check box under the reply)