Would like to understand the "reasoning" of our request.
Why are you forced to use two sheets? Would a dual axis chart and synchronize be an option?
Thanks for your answer.
It would not be possible to use a dual axis chart : on a first graph I have a reference and a target, on the second one : the monthly follow-up.
Is it possible to synchronize the 2 Y-axis ?
Without a view on your workbook;) You can "synchronize our Y-axis. At the same time you could "store" to measures one the left Y-ax and the third measure on the right X