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 :)


    Indie

    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!

Register Yourself Login