Is this possible in Excel?

[deante]

I have been trying to create a sheet in excel for a while. I am have a large set of data in one sheet that contains column headings for each set. I would like to take this data and create charts for each different operation. Each operation chart will have the same information, just for that specific operation. I can create the chart for each charts using macros and other programming. However, I would like select four or five charts at a time, put them on one page, but only the ones selected.

Operation Min Amount Total Amount of Operation
Operation 1 50 120
Operation 2 100 150
Operation 3 80 130

I would like to specify a max min amount for the three operations is 250, this number changes often. Then if I change the amount of operation 1 from 50 to 100, I would like operations 2 and 3 to change as well if the increase of operation 1 makes the max min number more than the specified max min. I want each operation to go down a percentage of the total amount. So, operation 2 min amount would go from 100 to 73 because operation 2 has 53.5% of the total amount from operation 2 and operation 3. Therefore it decreases by a rate of 53.5% of the increase of operation 1. Operation 3 would decrease from 80 to 57
due having 46.5% of the total amount between operation 2 and operation 3. The % is not from the min amount but a total of the Total amount of operation.


This has been a very trying process any help would be greatly appeciated, and you would be a certified excel genious in my book

Thanks

 

[ThomasLafferty]

Could you tell me which of the values in the columns below are constants, and which are formulas?

Operation Min Amount Total Amount of Operation
Operation 1 50 120
Operation 2 100 150
Operation 3 80 130

Also, is your specified Max value a total of all three values, or is it a constant which you will update by hard enter by hand?

Tom

 

[deante]

Only the operations are constant, The min amount and Total Amount of Operation are pulled from a data sheet that changes often. Also, you will hard enter the max value each time you want to adjust the min amount.

Thanks for your help

 

[ThomasLafferty]

So then the min amount is something like:
=Sheetref!CellRef to return the min value on the sheet where you want the summation to appear, yes? Could you give me an idea of how the data is laid out on the changing sheet? If you have them organized in list style with field names at the top of the column, it is then a fairly straight forward matter to manipulate the values on that sheet before pulling them into the other sheet, or do I misread you? How is the data on the frequently changing sheet laid out?

Tom