adding one more question to that.
is it possible to hide the sheet 2 and 5 by default until the sheet 4 is pressed
if yes, how ? please help
I got something working pretty close to what you're looking to do. See the attached updated workbook.
Since you're looking for a two step action process I had to add a second bar chart for Segment to get it to work.
By default, neither table is showing. If you click the Region chart (sheet 4) then Sheet 5 will appear. if you click the Segment chart (sheet 4(2)), Sheet 2 will appear and 5 will disappear. If you clear both clicks, both tables will be hidden again.
Let me know if you have any questions.
dual axis (1)_v10.3.twbx 1.3 MB