You will have to change the chart type and place the graph below in a vertical container. Attaching the workbook . Let me know if it helps.@
Dynamic view.twbx 255.4 KB
Find my approach,
1. Put a Horizontal container before your Sales worksheet
2. Place both Sales and Quantity worksheets in Horizontal container.
3. Convert the Quantity chart into bar graph and hide the Title of the sheet. You can see the attached workbook how to show Quantity label in the worksheet as title.
Once done then you can check the sheet hide/show option.
Let us know if this help.
Dynamic view_v10.5.twbx 253.1 KB