Overlay Pivot Slicer Graphs

  • I have a data table and pivot slicers of various criteria. If I select say 3 like criteria and then the last criteria is the running total of profit/loss for a 5 day period, this displays on a line chart. If I pick another 5 day period it displays another line chart. Is there a way to overlay all 5 day periods onto one chart. In the attached screenshot, I've taken a picture of three 5 day period profit/loss line charts, and overlayed them The X and Y axis have different ranges which makes it difficult.

    The idea is, if the X axis all correspond then I can see in an instant what range is profitable and what's not?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!