Forum Discussion
Steffi_Kaizun
Aug 26, 2023Copper Contributor
Create new worksheet with one graph using single cell input from multiple worksheets
GIVEN: - I have an Excel 2003 (don't yell at me!) spreadsheet with multiple worksheets. - Each worksheet has two columns (text label, numeric value) and a graph showing all the columns' values. - ...
Steffi_Kaizun
Copper Contributor
K.I.S.S.
PeterBartholomew1
Sep 03, 2023Silver Contributor
K.I.S.S.
A fine principle but the devil is in the interpretation! I tend to find myself travelling in the opposite direction to my financial modelling friends, each searching for 'simplicity'. For me, a single array formula that captures the entire problem is simplicity, for them it is the huge array of scalar formulas that is simple. For me, it is sticking to primitive elements of the calculation that makes the overall structure difficult to visualise.
- Steffi_KaizunSep 03, 2023Copper ContributorWhy isn't there a way for the originator to "close" the thread?
- HansVogelaarSep 03, 2023MVP
You can mark a reply as 'the answer' if applicable. But even then, the thread will remain open for discussion.