Oct 28 2023 11:34 AM
Hello Everyone,
I have created a spreadsheet to record my weight fluctations by each month. I keep this as a record for my ENT care support team after undergoing 30 successful radiotherapy sessions for throat cncer. I have also created this as an ongoing project to maintain my sanity and encourage my brain cells.
As you will see from the attached sheet, I have my data in a tab and a seperate tab for each two month period. I have just inserted a text box to show a summary of Min/Max/Average weights for each month. Instead of manually inputting these figures, is it possible to include the data in the chart direct from the cell?
Many Thanks,
Bob
Oct 28 2023 12:11 PM
Create a single cell with Wrap Text turned on, and a formula that returns the desired info in that cell.
You can concatenate with CHAR(10) to insert a line break in the formula result.
Next, click on the text box to select it.
Then click in the formula bar and point to the cell mentioned above, and finally press Enter.
Oct 29 2023 05:12 AM
Oct 29 2023 05:27 AM
SolutionAfter clicking in the formula bar:
I have attached a small demo workbook.
Oct 29 2023 08:40 AM
Hans,
Many Thanks for your assistance with this. After a bit of moving things around, I was able to follow your instructions. See the attached file.
Regards,
Bob