Forum Discussion
Include Cell Data in a Chart
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 sessio...
After clicking in the formula bar:
- Type =
- Activate the sheet with the cell you want to refer to.
- Select the cell. You should see a formula such as =Sheet1!$G$10.
I have attached a small demo workbook.
Thanks Hans,
I managed that so far but could not really find what to do with "Then click in the formula bar and point to the cell mentioned above, and finally press Enter.".
After I select the text box in the chart, there is no option to select a cell in the Formula Bar (Drop Down Menu), can you explain please? My data is in a separate tab from the chart tab, does this make a difference?
Regards,
Bob
I managed that so far but could not really find what to do with "Then click in the formula bar and point to the cell mentioned above, and finally press Enter.".
After I select the text box in the chart, there is no option to select a cell in the Formula Bar (Drop Down Menu), can you explain please? My data is in a separate tab from the chart tab, does this make a difference?
Regards,
Bob
After clicking in the formula bar:
- Type =
- Activate the sheet with the cell you want to refer to.
- Select the cell. You should see a formula such as =Sheet1!$G$10.
I have attached a small demo workbook.
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,
BobWell done, congratulations!
