Forum Discussion
growing table
- Oct 07, 2020
Maxwellq Why not simply convert your data into a structured table (Ctrl-T) and run your graph off that table. Such tables expand automatically and anything referring to the table as a whole or a column that is part of the table will expand with it as demonstrated in the attached file. Just add a few lines of dates and weights at the bottom and see what happens.
Maxwellq Why not simply convert your data into a structured table (Ctrl-T) and run your graph off that table. Such tables expand automatically and anything referring to the table as a whole or a column that is part of the table will expand with it as demonstrated in the attached file. Just add a few lines of dates and weights at the bottom and see what happens.
- MaxwellqOct 09, 2020Copper ContributorYes! This is the stress-free “no sweat” solution.
The design of structured tables heeds the caveat not to use constants and absolute addresses, which is essentially the issue in the maintenance of maxwellq.xlsx.
To address my second question in maxwellq.xlsx you can add the function =MAX(WeightTable[Weight]) (although the usage doesn’t appear to work in the older .xls version).
I removed the ostentatious blue stripes by reformatting the cells with data using the fill-color “white”.
Thank you very much.- Riny_van_EekelenOct 09, 2020Platinum Contributor
Maxwellq Uploading my original file again, with several formulae in column N, that pick the highest weight from column B. See which one suits you best.