consolidate charts from multiple pivot tables

[Nicawette]

Dear all,

I have 3 different pivot charts based on three different pivot tables.
I would like to consolidate these three charts in one.
I have already tried to move all the charts on one sheet and remove
the fill of the graph so I can visualize the three data series (in
transparency) but adapting the format axis when filtering the value is
a nightmare.
Do you have any idea how to consolidate all the data series on 1
graph?

Thank you

Nicolas