Creating fixed graphs

  • Hi, I'm looking for a way to create graphs where the source data is taken as a snapshot so the cells that contain it can be changed and used to create a second graph without affecting the first. Is that possible?

    Thanks :)


  • Re: Creating fixed graphs

    theres probably a better way
    but if you use a pivot chart , that should not update until a refresh is applied

    see attached

    the values where 1,2,3,4 when i created the pivot chart
    and then changed the values - and you will see the chart on sheet 1 changed - but the pivot chart on sheet 4 will not change until refresh

Participate now!

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