Table Generator

[maxwelln1]

Hello,

I would like to generate a table with two columns 'X' and 'Y'. The user will be required to enter the 'start', 'end' and 'interval' that will make up the 'X' column, the 'Y' column contains a simple formula. These values will the be plotted on a chart.

I have done this manually in the attached example but would like a way to automate this, as I can't seem to find a way to do it. Any help appreciated!

[FDibbins]

If you use a structured table, it will grow as needed as they enter data

[maxwelln1]

Thanks for the reply - I had tried this, but I need to be able to also reduce the number of rows, eg one user might want to see a graph for 0-100 with intervals of 1, whereas another user might want to see 0-10 with intervals of 0.1. The structured table method falls over here as I can't find a way to remove rows automatically.

[JeteMc]

Perhaps the following will help
1. Populate cell E4 using: =C2
2. Populate cells E5:E103 using: =IF(E4<C$3,SUM(E4,C$4),"")
3. Populate cells F4:F103 using: =IF(E4="","",E4*2)
4. Produce a named range X_Range using Refers To: =OFFSET(Sheet1!$E$4,0,0,SUMPRODUCT(--(Sheet1!$E$4:$E$103<>"")))
5. Produce a named range Y_Range using Refers To: =OFFSET(Sheet1!$F$4,0,0,SUMPRODUCT(--(Sheet1!$F$4:$F$103<>"")))
6. Edit the series values for the chart to read: =Sheet1!Y_Range
7. Edit the axis label range for the chart to read: =Sheet1!X_Range
Let us know if you have any questions.