Hi,
I've made a sheet that does calculations on sizes of products and corresponding parcel sizes. There are two important output variables, I'll call them A and B here. A is an output from a calculation, but can be changed manually as well in order to optimize B, B is an output that's dependent on A. Now I'm looking for an optimum between A and B, however I don't want to try all possibilities manually so a chart would really help me out. is there a way that I can make a chart where I define a range of values for A and then see all the outcomes for B? Or can I somehow extract the outcomes of B for a range of A values in a table?
I hope it's a bit clear what Im trying to do..
Thanks!
I've made a sheet that does calculations on sizes of products and corresponding parcel sizes. There are two important output variables, I'll call them A and B here. A is an output from a calculation, but can be changed manually as well in order to optimize B, B is an output that's dependent on A. Now I'm looking for an optimum between A and B, however I don't want to try all possibilities manually so a chart would really help me out. is there a way that I can make a chart where I define a range of values for A and then see all the outcomes for B? Or can I somehow extract the outcomes of B for a range of A values in a table?
I hope it's a bit clear what Im trying to do..
Thanks!