I have a spreadsheet that uses several "switches" to include or exclude
certain data or calculations. I want to chart some of the results. I want the
values of the switches to be included in the chart, say within a text box.

Ex: I have a cell that is either "Yes" or "No" to determin whether the
revenue from oil production should be included. I also have a cell that is a
list of possible development scenarios. I want to include the value of this
cell too. I need more than one cell's value to be displayed at a time.

Ideally, it would be something like a text box (that can be placed anywhere)
that displays the value of a worksheet cell. This would allow labeling of the
chart to reduce confusion.