consolidate charts from multiple pivot tables
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
|