I want to display a cell's contents behind a chart?

[hedgeman50]

Is there a way to display the contents of a cell that is hidden behind a chart? In other words, I want for the cell's contents (in this case, a stock symbol) to appear as part of the chart. I'm looking for some kind of function like the "bring to front" command in MS Word. Thank you very much for any help!

 

[pilot]

How about linking to the cell you want displayed in the chart, like (part of) the title?

 

[hedgeman50]

The cell that is a copy of the cells through which I'm scrolling then has to be used in another equation. If I have part of a title in a chart as the active cell (e.g., if cell C3 is active and has MSFT in it...thereby putting MSFT as the title of the chart), can I then point another equation to that title?

My reason for doing this is that I'm dealing with complex formulas that may not be able to be changed (I'm not sure). These formulas need to point to a single cell to use in the equation. I want to have the cell as part of the chart, but if it's not possible, then I would like to simply hide the cell that is a copy of the active cell.

Thanks.

 

[Yogi Anand]

On 2002-09-21 13:56, hedgeman50 wrote:
Is there a way to display the contents of a cell that is hidden behind a chart? In other words, I want for the cell's contents (in this case, a stock symbol) to appear as part of the chart. I'm looking for some kind of function like the "bring to front" command in MS Word. Thank you very much for any help!

How about Right Clicking on the Object ... then in the context menu that pops up, select Order ... then Bring_to_Front

Does this work for you? If not explain a little further and let us take it from there.

Regards!

Yogi

 

[hedgeman50]

I've tried to send the object (the chart) to the front and to the back, and neither works. Unfortunately, a cell can't be brought to front like an object can be.

Any ideas?

Thanks.

 

[Yogi Anand]

On 2002-09-21 16:48, hedgeman50 wrote:
I've tried to send the object (the chart) to the front and to the back, and neither works. Unfortunately, a cell can't be brought to front like an object can be.

Any ideas?

Thanks.

You are right! a cell can't be brought to front like an object can be.

But in your original post you mentioned using the chart in MS Word ... perhaps you misstaed that for Excel.

Regards!

Yogi