Chart from changing value

[aeroboi]

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!

 

[OaklandJim]

Might you post an example of data that you are trying to get into the chart?

 

[OaklandJim]

To show data consider using MrExcel's excellent addin called XL2BB. It allows you to post segments of a worksheet called a "minisheet." Here is a link with all you need to do this.
XL2BB - Excel Range to BBCode