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
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
Re: Creating fixed graphs
Thanks, will see if I can work something suitable out using Pivot Charts
Don’t have an account yet? Register yourself now and be a part of our community!