1 independent variable and making a chart which fills automatically

Hi. basically I have this spreadsheet which calculates, through changing the number of solar panels and the type of solar panel, the total installation price and annual profit etc etc.

I want a table where number of panels increases and all my dependant variables fill in automatically. I can make the first row of it fine, each cell is just a reference to the cell where it was calculated, but then how do i make the second row fill in with all the new values from when number of panels = 4 instead, considering that i still have to reference to the same cell?

Thanks for any help

Hi,

Welcome to the Forum.

Can you please post a sample template of your workbook using "Go Advanced" option? You may choose to delete the confidential information in the file before upload, if any.

so here is the attatched file. i hope thats what you meant. go to the control sheet, N63-V63 is the chart titles and below are the values for the criteria shown on the left of the s-s. The values (N76-V76) are all there as formulas to another cell. I am incrementing No. of panels by 2 and examining the changes of these others. im just looking for a clean method of putting this into a chart. THANKYOU!!!!